Re: [JBoss-user] Retrieving large lists
On Tue, 2003-03-18 at 23:09, Philippe de M. Sevestre wrote: How often does the data from which you populate your pull-down changes ? Usually this kind of information is relatively static so you should consider caching the resulting bean collection in a session attribute (if user specific) or even a context attribute. I do actually use this technique on the more static data. It is the stuff that cannot be cached which causes me problems. However, other posts have indicated that I can probably do more with my read-ahead strategy than I am at the moment. Thanks -- Peter Beck BEng (hons) MIEE - Managing Director, Electrostrata Ltd. http://www.electrostrata.com --+-+-- Experts in e-business and e-commerce --- This SF.net email is sponsored by: Does your code think in ink? You could win a Tablet PC. Get a free Tablet PC hat just for playing. What are you waiting for? http://ads.sourceforge.net/cgi-bin/redirect.pl?micr5043en ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] Retrieving large lists
if you are using cmp 2 i suggest you to look at the read-ahead parameters on the jboss cmp doc. Pete Beck wrote: Hi, My application frequently needs to grab a large number of entities from the database to populate drop down lists. The current method I use, is to use a CMP finder which returns a bunch of entities. I then iterate through the list grabbing the values I need to populate the list. But, it is too slow! I usually need only two fields from each entity, and the overhead of converting each row into a bean is high. I am using the read-ahead optimisation. My only option to speed this up seems to be a SQL+JDBC solution. Does anyone have any better suggestions for me? Thanks, Pete --- This SF.net email is sponsored by: Does your code think in ink? You could win a Tablet PC. Get a free Tablet PC hat just for playing. What are you waiting for? http://ads.sourceforge.net/cgi-bin/redirect.pl?micr5043en ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] Retrieving large lists
How often does the data from which you populate your pull-down changes ? Usually this kind of information is relatively static so you should consider caching the resulting bean collection in a session attribute (if user specific) or even a context attribute. - Original Message - From: Pete Beck To: [EMAIL PROTECTED] Sent: tera-feira, 18 de maro de 2003 13:50 Subject: [JBoss-user] Retrieving large lists Hi, My application frequently needs to grab a large number of entities from the database to populate drop down lists. The current method I use, is to use a CMP finder which returns a bunch of entities. I then iterate through the list grabbing the values I need to populate the list. But, it is too slow! I usually need only two fields from each entity, and the overhead of converting each row into a bean is high. I am using the read-ahead optimisation. My only option to speed this up seems to be a SQL+JDBC solution. Does anyone have any better suggestions for me? Thanks, Pete -- Peter Beck BEng (hons) MIEE - Managing Director, Electrostrata Ltd. http://www.electrostrata.com --+-+-- Experts in e-business and e-commerce --- This SF.net email is sponsored by: Does your code think in ink? You could win a Tablet PC. Get a free Tablet PC hat just for playing. What are you waiting for? http://ads.sourceforge.net/cgi-bin/redirect.pl?micr5043en ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user --- This SF.net email is sponsored by: Does your code think in ink? You could win a Tablet PC. Get a free Tablet PC hat just for playing. What are you waiting for? http://ads.sourceforge.net/cgi-bin/redirect.pl?micr5043en ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user