diff options
Diffstat (limited to 'scripts/create_index.py')
| -rw-r--r-- | scripts/create_index.py | 21 |
1 files changed, 0 insertions, 21 deletions
diff --git a/scripts/create_index.py b/scripts/create_index.py deleted file mode 100644 index 823e616..0000000 --- a/scripts/create_index.py +++ /dev/null @@ -1,21 +0,0 @@ -import sqlite3 - -con2 = sqlite3.connect("py-new.db") -con2.execute ("PRAGMA synchronous = NORMAL;") -con2.execute ("PRAGMA temp_store = MEMORY;") - - -con2.execute("CREATE INDEX index_0_0 ON py_phrase_0(s0, y0)") -print "py_phrase_%d done" % 0 - -con2.execute("CREATE INDEX index_1_0 ON py_phrase_1(s0, y0, s1, y1)") -con2.execute("CREATE INDEX index_1_1 ON py_phrase_1(s0, s1, y1)") -print "py_phrase_%d done" % 1 - -for i in xrange(2, 16): - con2.execute("CREATE INDEX index_%d_0 ON py_phrase_%d(s0, y0, s1, y1, s2, y2)" % (i, i)) - con2.execute("CREATE INDEX index_%d_1 ON py_phrase_%d(s0, s1, s2, y2)" % (i, i)) - print "py_phrase_%d done" % i - -# con2.execute("vacuum") -con2.commit() |