From fafbde26383e42858538046d4b2b3691e21bd898 Mon Sep 17 00:00:00 2001
From: dumpfmprod <dumpfmprod@ubuntu.(none)>
Date: Sun, 24 Oct 2010 20:16:20 -0400
Subject: Update python scripts

---
 scripts/fill.image_urls.py | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'scripts/fill.image_urls.py')

diff --git a/scripts/fill.image_urls.py b/scripts/fill.image_urls.py
index 79280b9..4f7c2ea 100644
--- a/scripts/fill.image_urls.py
+++ b/scripts/fill.image_urls.py
@@ -12,6 +12,13 @@ def get_num_images_in_db():
   ps = db.prepare("SELECT COUNT(*) FROM image_urls")
   return int(ps()[0][0])
 
+def vacuum_and_analyze():
+  print("cleaning db")
+  ps = db.prepare("VACUUM image_urls")
+  ps()
+  ps2 = db.prepare("ANALYZE image_urls")
+  ps2()
+
 def add_url(url):
   try:  
     print(url)
@@ -83,3 +90,4 @@ if __name__ == "__main__":
   num_new_images = get_num_images_in_db() - num_existing_images
   percent_new_images = num_new_images / len(urls) * 100
   print(num_new_images, " were new (", percent_new_images ,"%)")
+  vacuum_and_analyze()
-- 
cgit v1.2.3-70-g09d2