From 0861fdc7cb0d07cacbfd0d8b9e7914ec7e623c88 Mon Sep 17 00:00:00 2001 From: Vincent Le Gallic Date: Wed, 10 Feb 2016 08:42:58 +0100 Subject: [PATCH] [bde/credits_duplicates] Indexons donc cette table temporaire, afin de gagner *masss* temps --- bde/credits_duplicates.py | 2 ++ 1 file changed, 2 insertions(+) diff --git a/bde/credits_duplicates.py b/bde/credits_duplicates.py index dc98725..e9185d3 100755 --- 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, -- 2.39.2