This script can be run periodically (e.g. as a nightly cronjob) to keep a SQLite database with high churn from growing unnecessarily large.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | from django.conf import settings
def vacuum_db():
from django.db import connection
cursor = connection.cursor()
cursor.execute("VACUUM")
connection.close()
if __name__ == "__main__":
print "Vacuuming database..."
before = os.stat(settings.DATABASE_NAME).st_size
print "Size before: %s bytes" % before
vacuum_db()
after = os.stat(settings.DATABASE_NAME).st_size
print "Size after: %s bytes" % after
print "Reclaimed: %s bytes" % (before - after)
|
More like this
- Template tag - list punctuation for a list of items by shapiromatron 10 months, 4 weeks ago
- JSONRequestMiddleware adds a .json() method to your HttpRequests by cdcarter 11 months ago
- Serializer factory with Django Rest Framework by julio 1 year, 5 months ago
- Image compression before saving the new model / work with JPG, PNG by Schleidens 1 year, 6 months ago
- Help text hyperlinks by sa2812 1 year, 7 months ago
Comments
An update to make it work with multiple connection in Django 1.2:
#
Please login first before commenting.