We are looking for database maintenance commands for the Sqlite database and
came across 2 commands which we felt that it would improve the performance if
used. The commands are VACUUM and REINDEX. I came to know that VACUUM just
helps us to reclaim the space and does not give any performance increase. Just
wanted to check of REINDEX or any other Sqlite command which you suggest users
to run it every month?
Our database size varies from 30GB to 50 GB,with various operations like
insert/update/delete would be performed on day to day basis.Just wanted to know
if there is a need to maintain the sqlite database so that the performance does
not degrade or just leave as it is.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
