Optimizing Database Access JDBC?

[Patrick25FFM]

Hi all,

I am trying to get a lot of data from a microsoft sql database with jdbc and write these data in files to the harddisk.

Unfortunately my program is getting slower step by step. (I can see this at the amount of files written at the harddisk in a fix timeslot).

I am using PreparedStatements and Resultsets.

Does anybody have some suggestions for speeding up the database access?

Thank you in advance for your help.

Kind regards, Patrick.

 

[Oliver Gierke]

Do you use a pooled connection (Apache Commons DataSource e.g.)? How do you clean up resources? Do you clean 'em up at all?

Regards
Ollie

 

[Thomas Darimont]

Hello,

which JDBC Driver do you use?

Best regards,
Tom