From: kennedy-downwithspammersfamily@attbi.net   
      
   "Howie Goodell"  wrote in message   
   news:20bf32b7.0407131149.4e164369@posting.google.com...   
   > 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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)