Project:
| View Revisions: Issue #29612 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0029612: Extend the grid configuration to improve the performance of the population of foreign key dropdowns | ||
| 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 |
 |