Server crashes...

[Praveen Potineni]

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