Forums Register Login

experience with databases and jdbc-drivers

+Pie Number of slices to send: Send
hi all,
I'd like to know if someone has experience with the postgresql, mysql, sybase, oracle managing _lots_ of data or with database access both using java and perl.
for the task (I am looking for a solution), most of the time the data will be selected one row at a time (certainly using an index). on the other hand, it will be necessary to regularly parse large textfiles and insert the new data.
i'd like to do all that using java, but i'm afraid, a parser written in java will be quite slow - i'd like to get an objection to this!
moreover, I've heard, that the jdbc-driver (from postgres) for PostgreSQL (that i'm using at the moment) is not reliable when inserting a lot of data. has someone experienced anything alike? what about the other drivers one gets listed at sun's, that seem to work for postgres as well: has someone used different jdbc-drivers with the postgresql?
thanx for your advice
chantal
He does not suffer fools gladly. But this tiny ad does:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 806 times.
Similar Threads
Creating Temp table and querying it
Postgres on WSAD 5.1 - it works
Postgres using hypersonic mappings?
Tutorial PostgreSQL 8.3 on Glassfish V2.1 for ConnectionPool in Netbeans 6.5.1, WindowsXP (Post 3)
error when going to forum from forum list
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 23:08:19.