Project:
View Revisions: Issue #27046 | [ Back to Issue ] | ||
Summary | 0027046: Product simple selector is executing a query in database without limit | ||
Revision | 2014-07-10 18:59 by jecharri | ||
Steps To Reproduce | -Login as "system" and go to "tables and columns" -Select table "c_orderline" and column "m_product_id" -Change the column reference to "OBUISEL selector reference" and set "Product simple" selector -Stop tomcat -Edit "log4j.lcf" file to display sql queries to be executed log4j.logger.org.hibernate.SQL=debug, HB -Compile -Start tomcat -Login as "Admin" -Go to window "sales order" create a header and press new line -Click in the selector to display all the products If you go to eclipse console or openbravo.log file, you will see that at this moment SQL query is executed in database without limit This is a big performance problem when you have more than 1 million of products. |
||
Revision | 2014-07-10 18:59 by jecharri | ||
Steps To Reproduce | -Login as "system" and go to "tables and columns" -Select table "c_orderline" and column "m_product_id" -Change the column reference to "OBUISEL selector reference" and set "Product simple" selector -Stop tomcat -Edit "log4j.lcf" file to display sql queries to be executed log4j.logger.org.hibernate.SQL=debug, HB -Compile -Start tomcat -Login as "Admin" -Go to window "sales order" create a header and press new line -Click in the selector to display all the products You will see that at this moment SQL query is executed in database without limit This is a big performance problem when you have more than 1 million of products. |
Copyright © 2000 - 2009 MantisBT Group |