Let user switch off database indices before feeding data.

tomaso / goove

Overview webapp for torque accounting

0 stars 0 forks source link

Let user switch off database indices before feeding data. #13

Closed tomaso closed 13 years ago

tomaso commented 13 years ago

The dataimport.py should have an option to remove database indices, process a file (or a set of files) and then build the indices again. For big files or large number of files, this approach can be faster than adding rows and changing indices automatically.

tomaso commented 13 years ago

According to my tests, removing indices is not efficient (because we do lot of SELECTs during data feeding).