If you boss told you to jump out of the Window would you do it. You need to make sure that what u are trying to do make sense. The most records that i have returned was about 1000 (And it took several seconds just to display). I have to agree with Richard that < 100 records is the most that you want to return from a database. When i returned 1000, i was able to get my boss to see the light that this was to slow.
Daniel Jaffa ----Original Message Follows---- From: Praveen Potineni <[EMAIL PROTECTED]> Reply-To: A mailing list about Java Server Pages specification and Comments: To: Tomcat Users List <[EMAIL PROTECTED]> Hi all, Thanks for the suggestion you have given on this topic. Though my intention is not to make the user surf thru all the million records, but i was trying to test such a big load. Our application is in the initial stages of development and i was trying to see if tomcat can handle such a big load. I'm using Sybase ASA 6.0 and jConnect sybase driver for JDBC. Yeah ..I would definately narrow my query to retrieve few records to display. I was trying to do what my boss had asked me to do. Thanks again. Praveen ----- Original Message ----- From: "Richard Troy" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Cc: "JSP_INTEREST" <[EMAIL PROTECTED]> Sent: Thursday, November 08, 2001 3:53 PM Subject: Re: Server crashes... > > Praveen, > > You have a query returning a million rows and you want to make the data > access quick. Hmmm... I have to question your strategy. HTML and the world > wide web are oriented toward serving humans directly and while I'm not > saying it's impossible, I find it hard to believe that there's a > legitimate reason for a human being to try and look at a million result > rows on a web page. If you are serving a human being, reduce the result > set to something reasonable. You didn't say your query uses SQL but > presuming that it is, use the WHERE clause. A reasonable return value for > a real human being is probably less than one hundred, or thereabouts. If > your application is not serving a human being, then use a direct, non-html > based application approach - traditional client-server style. > > Hope this helps, > RT > Richard Troy, Chief Scientist > Science Tools Corporation > [EMAIL PROTECTED], 510-567-9957, http://ScienceTools.com/ > > On Thu, 8 Nov 2001, Praveen Potineni wrote: > > 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 _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
