[bde/credits_duplicates] Indexons donc cette table temporaire, afin de gagner *masss...

[scripts-20-100.git] / bde / credits_duplicates.py

diff --git a/bde/credits_duplicates.py b/bde/credits_duplicates.py
index dc98725954ae128f452873ad2c1b6027686f307b..e9185d3b742d412c805003ea0e8d061182065c4c 100755 (executable)
--- a/bde/credits_duplicates.py
+++ b/bde/credits_duplicates.py
@@ -48,6 +48,8 @@ def get_data(cur, delai='1 minute', date='1970-01-01'):
     """
     cur.execute(req_create_credits)
 
+    cur.execute("CREATE INDEX credits_index_id ON credits (id);")
+
     req = u"""
         SELECT
             t1.id AS id1,