Re: Help jdbc performance sloooow...

I have only used JDBC a little, so I am not as familiar with it as ODBC.

But I can tell you that with ODBC, you can ask for a huge batch of records at once
(say 500) with each fetch, and that makes a dramatic (i.e., 10 to 1 sometimes) difference in speed.

I'm assuming JDBC has a similar ability, but I am not certain. Clearly transferring one row at a time is not a good thing...

Steve

wrote in message <7cp5vn$40k$1_at_nnrp1.dejanews.com>...
>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 24 1999 - 11:38:16 CST