search

SyuTingSong / phpliteadmin

Automatically exported from code.google.com/p/phpliteadmin
0 stars 0 forks source link

Optimize Alter Table Speed in case of sqlite3 #237

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Currently, the ALTER TABLE workaround copies the data of the table twice, first 
in a temporary table and then in the new target table.
As SQLite3 can rename tables, it would be possible to rename the temporary 
table into the final table name without the need to copy the data again.
So altering a big table would only need about half the time it currently needs.

Original issue reported on code.google.com by crazy4ch...@gmail.com on 25 Dec 2013 at 1:13