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