[pypy-issue] [issue839] Sqlite in pypy 1.6 on amd64 is very slow :)

Antonio Cuni tracker at bugs.pypy.org
Thu Sep 1 18:09:39 CEST 2011

Antonio Cuni <anto.cuni at gmail.com> added the comment:

indeed, I confirm that sqlite3 is very slow on PyPy.
I tried with the following example:

def main():
    import sqlite3
    conn = sqlite3.connect(':memory:')
    conn.execute('CREATE TABLE foo(id INTEGER)')
    cursor = conn.cursor()
    for i in range(10000):
        SQL = 'INSERT INTO foo VALUES (0)'

pypy-c took 1.11 seconds, while CPython 0.03 (!!)

Revisions 862677259356 and 72321d3c8b69 mitigates a bit the problem.  Now it
takes only 0.5 seconds on top of pypy-c, but it's still ~16x slower than
CPython. I'll try to investigate more

PyPy bug tracker <tracker at bugs.pypy.org>

More information about the pypy-issue mailing list