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: terça-feira, 18 de março 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