Thread: What is the best way to defragment the SQL database?
View Single Post
Old 05-16-2012, 08:49 AM   #4
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,471
Karma: 8025600
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by gaspine View Post
execute the "vacuum" sql insctruction, cause sqlite3 keep space when used 1 time :
http://www.sqlite.org/lang_vacuum.html
Calibre's check library will reclaim space used by orphaned records and guarantees row ids will not change, neither of which vacuum does.
chaley is offline   Reply With Quote