Project:
| View Revisions: Issue #35210 | [ Back to Issue ] | ||
| Summary | 0035210: sequential scans in c_bpartner using partner selector drop down filter | ||
| Revision | 2017-02-09 10:11 by alostale | ||
| Steps To Reproduce | 1. Open Sales Order window 2. Create a record 3. in psql reset stats: select pg_stat_reset(); 4. Type "alimentos" in BP selector text field 5. in psql check stats for bp table: select seq_scan, idx_scan from pg_stat_user_tables where relname = 'c_bpartner'; -> check it is sequentially scaned |
||
| Revision | 2017-02-09 10:05 by alostale | ||
| Steps To Reproduce | 1. Open Sales Order window 2. Create a record 3. in psql reset stats: 4. Type "alimentos" in BP selector text field 5. in psql check stats for bp table: |
||
| Revision | 2017-02-09 10:00 by alostale | ||
| Description | Whenever business partner selector is filtered using drop down list, a sequential scan is performed on BP. This problem has been found in a customer with ~120K BPs. |
||
| Revision | 2017-02-09 09:59 by alostale | ||
| Description | Whenever business partner selector is filtered using drop down list, a sequential scan is performed on BP. | ||
| Copyright © 2000 - 2009 MantisBT Group |
 |