1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
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()
|