Hello, [After posting this message directly to the mailing list earlier, I got the impression that using the online forum is the preferred way. Sorry for the repetition.]
Using JBoss 3.2.6, our application queries a MySQL (4.0.23) database with a dynamic JBossQL query that contains a LIMIT clause. However, in the SQL query that is generated by the container to be processed by MySQL, unfortunately no LIMIT clause appears, causing MySQL to do a lot more work (taking a lot more time) than is actually necessary (finding and sorting 100.000 records in stead of just the first 100). Unfortunately, it doesn't seem possible to further optimize at MySQL level (e.g. by adding even more indexes). So, why does JBoss not actually preserve the LIMIT clause on the generated SQL query? Of course, I really wonder whether it is possible to add configuration to make this happen after all? Thanks a lot! Yours, Jurjan-Paul Medema View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3879007#3879007 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3879007 ------------------------------------------------------- This SF.Net email is sponsored by Yahoo. Introducing Yahoo! Search Developer Network - Create apps using Yahoo! Search APIs Find out how you can build Yahoo! directly into your own Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
