0027046: Product simple selector is executing a query in database without limit

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #27046		[ All Revisions ] [ 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.