Thanx Jacob Initially I was wondering that querying to request base will be a performance issue. If even the "big" sites are doing this way, then I guess it should not be a problem
-----Original Message----- From: Hookom, Jacob John [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 5:30 PM To: Struts Users Mailing List Subject: RE: Design Doubt Create an action that takes in the start id and the quantity to scroll over, and your query (total of 3 params). Read up on your DB specific SQL language for specifying a start id and max rows to return (not applicable for this mailing list). Enstate whatever kind of caching you want, but leave querying to request based only. That's how most "big" sites do it. -Jacob -----Original Message----- From: Jagadeesan,Sivakumar [mailto:[EMAIL PROTECTED] Sent: Wed 3/26/2003 5:20 PM To: 'Struts Users Mailing List' Cc: Subject: RE: Design Doubt I will chk the displayTag. I think putting data in a ArrayList of beans will be problem , if there are many data present in the database. For example, if there are 1000 rows then we will be creating 1000 beans. I don't think this is good idea. -----Original Message----- From: Raible, Matt [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 5:16 PM To: 'Struts Users Mailing List' Subject: RE: Design Doubt Easiest way without too many details (lots of opinions on getting data from database): 1. Put data into an ArrayList of Beans (forms, POJOs, whatever). 2. Use display tag library for display/sorting/paging - http://displaytag.sf.net (it's open source, so if you want to improve it feel free!) Matt > -----Original Message----- > From: Jagadeesan,Sivakumar > [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 26, 2003 4:09 PM > To: 'Struts Users Mailing List' > Subject: Design Doubt > > > * I want to develop a Product Catalog. > * The product list is present in the database > * I want to display 10 products in one JSP page. I don't want > to load all > the > products from the Database and keep it in the memory. I also > don't want to > return > the ResultSet to the Servlet/JSP Layer. > > What is the best way to do this ? > > This is common functionality almost all the web sites have, > but for some > reason I am not able to figure it out. > > --Siva Jagadeesan > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
