Re: Server crashes...

[Sreemushta, Santhosh (c)]

I don't think its a good idea to use Tomcat when your query is returning more than a million record.  I'm not sure whether even a heavy duty app server will also handle one million records in the memory.  Try setting the row count while retrieving record or increase JVM settings in your Tomcat (usually its around 64MB).   -----Original Message----- From: Praveen Potineni [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 08, 2001 3:22 PM To: [EMAIL PROTECTED] Subject: Server crashes... Hi all, I have a query which gets 1 million records. When i try to query from a bean and access it from JSP(i'm using Tomcat 4.0 on win 2000), the application takes forever and finally crashes on me. It says running out of virtual memory. I have a question: What is the physical location of the resultset. When i do a query where is the result set coming and storing all the values.What is the physical location of the data that is being retrieved.   How can i make the data access quick.   Thanks Praveen