libQL3

import sqlite3, time

conn = sqlite3.connect(':memory:')

cursor = conn.cursor()

colnum = 999

rownum = 500

# create table query

columnnames = ["col"+str(i) for i in range(colnum)]

createquery = "CREATE TABLE customer(id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "

for i, name in enumerate(columnnames):

    createquery = createquery + name + " REAL"

    if i != colnum-1:

        createquery = createquery + ", "

createquery = createquery + ")"

# create table query execution

#print createquery

cursor.execute(createquery)

# generating rows data

rows = []

for row in range(rownum):

    newcol = ()

    for col in range(colnum):

        newcol = newcol + (row*0.1, )

    rows.append(newcol)

#print rows

# insert query

insertquery = "INSERT INTO customer("

for i, name in enumerate(columnnames):

    insertquery = insertquery + name

    if i != colnum-1:

        insertquery = insertquery + ", "

insertquery = insertquery + ") VALUES("

for i in range(colnum):

    insertquery = insertquery + "?"

    if i != colnum-1:

        insertquery = insertquery + ", "

insertquery = insertquery + ")"

#print insertquery

# starting timer

t = time.time()

# insert query execution

conn.executemany(insertquery, rows)

conn.commit()

print "\n Time Taken: %.3f sec" % (time.time()-t)