Re: Help jdbc performance sloooow...

afrancis_at_my-dejanews.com wrote:

> 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

If this is a back end job, why don't you write a stored procedure in PL/SQL and call it and let do the work for you. ?

Dogan Received on Fri Mar 26 1999 - 12:02:58 CST