Skip to navigation
How too increase sqlite3 for python performance
07.12.13
how too increase sqlite3 for python performance # configure for fast writes lite_cur = lite_con.cursor() lite_cur.execute('PRAGMA synchronous = 0') lite_cur.execute('PRAGMA cache_size = 64000') lite_cur.execute('PRAGMA fullfsync = 0') lite_cur.execute('PRAGMA journal_mode = OFF') lite_cur.arraysize = 30000 http://pedro.larroy.com/blog/?p=526
Reply
Anonymous
con2 = sqlite3.connect("db/cart.db",isolation_level=None) c2 = con2.cursor() c2.execute('begin') c2.execute('insert....') c2.execute('insert') c2.execute('insert') c2.execute('commit')
07.12.13
Reply
Anonymous
Information Epoch 1746877293
When in doubt, use brute force.
Home
Notebook
Contact us
