I have a select sql statement with 2 order by parameters.It works in 0 sec in query analyzer and works fast with just 1 order by parameter when used with Java. However if I have 2 order by parameters it is reallllly slow...I don't know why this is happening ..any idea ??
I am using Jboss 3.2.3, Sql server..... Any idea anyone ? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3864908#3864908 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3864908 ------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
