Help jdbc performance sloooow...

Hi,

I've got a java program that selects from an oracle database that has 80 million rows and is tuned for speed. It takes me nearly an hour to do my selection of 200,000 rows from an 80 million row database that's been bit-map indexed for speed.

I am using the thin driver because I haven't set up oci. I guess that's my first question:

Question 1: Will using oci driver enhance performance? (this is a backend application, runs in batch).

Right now I'm doing the select, doing some slight manipulation of the data (ie: concatenating fields, etc...) and then writing a record out to a file.

Question 2: Is there any way to "buffer" the result set? I have to do minor data conversion and then print it out in a certain format.

Question 3: Are there any "gotchas" as far as performance and doing selects?

Any and all input is appreciated.
TIA
Amy Francis

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 17 1999 - 15:14:40 CST