fetching 10000 or more records from oracle 9i
1 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
TOPIC ACTIONS:
 

Posted By:   struts_problem
Posted On:   Wednesday, May 7, 2008 06:51 AM

how to write jdbc code using statement to fetch 10000 records from oralce 9i using jboss 4.0.0 in minimum time

Report | Quote This | Send private message | Reply | Print

Re: fetching 10000 or more records from oracle 9i

Posted By:   Stephen_McConnell  
Posted On:   Wednesday, May 7, 2008 09:32 AM

If you are going to try to fetch that many records into memory with JDBC, you are going to have problems.

  1. You probably don't have enough memory.

  2. JDBC and Java is probably not the way to go if you are going to be processing THAT many records at one time.


What are you going to try and DO with those records all at one time?


Stephen McConnell

Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact