from testbase import con, cur cur.execute("create table foo (bar int, baz varchar)") for x in range(500): cur.execute("insert into foo values (?, ?)", (x, "string-value-of-"+str(x))) con.commit()
import time import itertools from testbase import con, cur BATCH = 500 for num in itertools.count(): for x in range(BATCH): n = (num * BATCH) + x cur.execute("insert into foo values (?, ?)", (n, "string-value-of-"+str(n))) con.commit() print(num, 'write pass complete', time.ctime())
import itertools import time from testbase import cur for num in itertools.count(): cur.execute("select * from foo") foovals = cur.fetchall() print num, 'I fetched', len(foovals), 'values.', time.ctime()
import time import itertools from testbase import con, cur BATCH = 500 for num in itertools.count(): for x in range(BATCH): n = (num * BATCH) + x cur.execute("insert into foo values (?, ?)", (n, "string-value-of-" + str(n))) con.commit() print num, 'write pass complete', time.ctime()
from testbase import cur cur.execute('create index foo_bar_idx on foo(bar)') cur.commit()
from testbase import cur cur.execute("create index foo_bar_idx on foo(bar)") cur.commit()
from testbase import con, cur cur.execute("create table foo (bar int, baz varchar)") for x in range(500): cur.execute("insert into foo values (?, ?)", (x, "string-value-of-" + str(x))) con.commit()