Project:
| View Revisions: Issue #33872 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0033872: Provide the means to disable/reenable programatically all the indexes of the database | ||
| Revision | 2016-09-01 13:20 by AugustoMauch | ||
| Description | This can be very useful, for install the import.sample.data process is much faster if the data is imported with the indexes disabled. Importing a big sample data(+1.300.000 rows in a few transactional tables, +300.000 busines partners, etc) takes 522923 milliseconds with the indexes enabled, and 259161 ms (49.5% of the current metric) with the indexes disabled (this measure includes the time spent disabling and reenabling the indexes). Note that the data load was done in both cases using PostgreSQL's COPY functionality, instead of using dllutils' DataReader as usual. |
||
| Revision | 2016-09-01 13:18 by AugustoMauch | ||
| Description | This can be very useful, for install the import.sample.data process is much faster if the data is imported with the indexes disabled. Importing a big sample data (+1.300.000 rows in a few transactional tables, +300.000 busines partners, etc) takes 522923 milliseconds with the indexes enabled, and 259161 ms (49.5% of the current metric) with the indexes disabled (this measure includes the time spent disabling and reenabling the indexes). |
||
| Revision | 2016-09-01 12:22 by AugustoMauch | ||
| Description | This can be very useful, for install the import.sample.data process is much faster if the data is imported with the indexes disabled. Metrics of the performance improvement will be included here when they are available. |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |