Revision b7181d0...
Go back to digest for 17th November 2013Optimization in KDE-PIM
Dan Vratil committed changes in [akonadi/parttable-optimization] server/src/storage/dbupdater.cpp:
Use update-during-copy-and-just-swap-tables approach to update PartTable
We create a PartTable_new with the new layout, populate
PartTypeTable, then we copy all data from PartTable to
PartTable_new and we modify the data on flight using
'INSERT INTO ... SELECT FROM ...' and then we just
rename PartTable_new to PartTable and drop the old one
This speeds up migration on MySQL by 50% as it avoids
copying the entire table twice for ALTER TABLE and also
works on SQLite
File Changes
Modified 1 files
- server/src/storage/dbupdater.cpp
1 files changed in total