You should turn on SQL trace in the hibernate properties and analyze the queries to figure out which indexes you will need. I did that with MySQL once to make it process the sql queries more efficiently.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3932307#3932307 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3932307 ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user