Project:
View Revisions: Issue #34072 | [ All Revisions ] [ Back to Issue ] | ||
Summary | 0034072: Adding an index on c_bpartner_location.c_location will speed certain processes | ||
Revision | 2016-09-23 12:20 by AugustoMauch | ||
Description | There are processes that given a location (table c_location) they need to retrieve if it is related with any business partner location (table c_bpartner_location). This results in the invokation of a query like this: SELECT * FROM c_bpartner_location WHERE c_location_id = ? In an environment with around 20 million entries in c_location and c_bpartner_location this query takes around 6 seconds. After adding an index in the column c_location of c_bpartner_location the query takes around 250 milliseconds (0000102:0000024 times faster). |
||
Revision | 2016-09-23 12:18 by AugustoMauch | ||
Description | There are processes that given a location (table c_location) they need to retrieve if it is related with any business partner location (table c_bpartner_location). This results in the invokation of a query like this: SELECT * FROM c_bpartner_location WHERE c_location_id = ? In an environment with around 20 million entries in c_location and c_bpartner_location this query takes around 6 seconds. After adding an index in the column c_location of c_bpartner_location the query takes around 250 milliseconds |
Copyright © 2000 - 2009 MantisBT Group |