Revision b7181d0...

Go back to digest for 17th November 2013

Optimization 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