469,643 Members | 1,486 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,643 developers. It's quick & easy.

Optimising Oracle 9i for million-record JDBC read-only access

Hello --

I am trying to optimise a JDBC connection and an Oracle 9i database
for reading millions of records at a time to a 1 Gig PC running Win2K
or XP. Two questions:

1. Does anyone have suggestions for optimising an Oracle 9i server
(Enterprise Edition, Release 2) for networked read-only JDBC access
with large return sets? With default settings MySQL reads 1M records
2.5 times faster than Oracle even on its first, non-cached execution.

2. Unrelated question: is there a way to read a text field via JDBC
without creating a String object? The memory and GC overheads of
creating millions of objects are becoming a problem, too.

Thanks much!
Howie Goodell
Jul 19 '05 #1
1 3612

"Howie Goodell" <ho***********@gmail.com> wrote in message
news:20**************************@posting.google.c om...
Hello --

I am trying to optimise a JDBC connection and an Oracle 9i database
for reading millions of records at a time to a 1 Gig PC running Win2K
or XP. Two questions:

1. Does anyone have suggestions for optimising an Oracle 9i server
(Enterprise Edition, Release 2) for networked read-only JDBC access
with large return sets? With default settings MySQL reads 1M records
2.5 times faster than Oracle even on its first, non-cached execution.

2. Unrelated question: is there a way to read a text field via JDBC
without creating a String object? The memory and GC overheads of
creating millions of objects are becoming a problem, too.

Thanks much!
Howie Goodell

Try increasing the array fetch or batch fetch to like 100 or so. Also use
prepared statements and reexecute. You can use the oci driver and it should
be faster.
Jim
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Syed Mudussir Husain | last post: by
3 posts views Thread by Andrew | last post: by
28 posts views Thread by prunoki | last post: by
56 posts views Thread by Ashish Patankar | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.