Hello,
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
-------------------------------------------------------
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
