Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #29612 Back to Issue ]
Summary 0029612: Extend the grid configuration to improve the performance of the population of foreign key dropdowns
Revision 2015-07-07 10:08 by alostale
Steps To Reproduce Implemented as a project: http://wiki.openbravo.com/wiki/Projects:Grid_Config_For_Foreign_Key_Drop_Down_Filters [^]
Revision 2015-07-07 10:07 by alostale
Steps To Reproduce -
Revision 2015-05-11 13:11 by AugustoMauch
Description The query done to populate the foreign key filter drop down can sometimes be slow, depending on the data of the table being filtered and on the data of the referenced table.

For instance, the query done to open the Organization filter drop down of the Product table can be very slow (>10 seconds) if the m_product table has millions of records, even if the Organization table contains less than a dozen of records

This project aims to extend the grid configuration to be able to improve the performance of this query.

Another useful configuration would be to get rid of the foreign key filter dropdown altogether, if its population is much heaviour than filtering the column like a standard text field. For this to work, issue 29732 [1] should be fix, to enable using indexes in that query.

[1] https://issues.openbravo.com/view.php?id=29732 [^]
Revision 2015-04-16 16:47 by AugustoMauch
Description The query done to populate the foreign key filter drop down can sometimes be slow, depending on the data of the table being filtered and on the data of the referenced table.

For instance, the query done to open the Organization filter drop down of the Product table can be very slow (>10 seconds) if the m_product table has millions of records, even if the Organization table contains less than a dozen of records

This project aims to extend the grid configuration to be able to improve the performance of this query.


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker