Re: Server crashes...

[Jean-Francois Pinero]

This could be useful to you, do a top 1000 or top X where X is the number of rows you want back....   Example:   SELECT     TOP 1000 * FROM         [dbo].[Table Name] -----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