keakon的涂鸦馆

import sqlite3
from random import random
from time import clock

rand = [(random(),) for i in xrange(1000000)]
con = sqlite3.connect(':memory:')
#con = sqlite3.connect('test.db')
cu = con.cursor()

cu.execute('''create table test (
id integer primary key,
value real)''')

t1 = clock()
cu.executemany('insert into test values (NULL, ?)', rand)
con.commit()
t2 = clock()

print cu.execute('select count(*) from test where value < 0.1').fetchone()[0]
t3 = clock()

print len(cu.execute('select * from test where value > 0.5 and value < 0.6').fetchall())
t4 = clock()

cu.execute('delete from test where value > 0.9')
con.commit()
t5 = clock()

cu.close()
con.close()

print t2 - t1
print t3 - t2
print t4 - t3
print t5 - t4

7.36210915074
0.396014577272
0.572679488594
0.767905697512

8.16458628122
0.534186328151
0.612970642917
2.01278710004