Dao's like OJB will help you with performance. I wouldn't recommend storing anything in the session like with the display tag, that's way too much wasted memory.
-Jacob | -----Original Message----- | From: Jagadeesan,Sivakumar [mailto:[EMAIL PROTECTED] | Sent: Wednesday, March 26, 2003 5:33 PM | To: 'Struts Users Mailing List' | Subject: RE: Design Doubt | | 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
