import os
import time
import sys
import sqlite3
from PyQt4.QtSql import *
from PyQt4.QtGui import *

filename = "db.db"
if os.path.exists(filename):
    os.unlink(filename)
  
app = QApplication(sys.argv)
db = QSqlDatabase.addDatabase("QSQLITE")
db.setDatabaseName(filename)
db.open()

q = QSqlQuery()

q.exec_("""CREATE TABLE test (number INTEGER NOT NULL)""")

t = time.time()
db.transaction()#!
for i in xrange(10000):
    q.exec_("INSERT INTO test (number) VALUES ('%s')" % i)
db.commit()
print time.time() - t

q.clear()
db.close() 

#-----------------------------

os.unlink(filename)

conn = sqlite3.connect(filename)
conn.execute('''create table test (number int)''')
conn.commit()

c = conn.cursor()

t = time.time()
for i in xrange(10000):
    c.execute('insert into test (number) values (%s)' % i)
conn.commit()
print time.time() - t

conn.close()