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

[Antonio Cuni]

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

As alex said, with the recent changes now sqlite3 is between 10% faster and 30%
slower than CPython.  Few notes:

- the first iteration is much slower on PyPy, because of the JIT warmup

- to get optimal results, we need to manually set trace_limit to 60000, else we
don't get the full ctypes/JIT optimization.  This is a problem, but it will
hopefully will fixed when we will be able to predict the trace length more
accurately in the frontend.

These are the results on my machine:
$ python bench.py
Took: 0.304196119308
Took: 0.30193901062
Took: 0.300392866135
Took: 0.301836013794
Took: 0.30334687233

$ pypy-c bench.py
Took: 0.797653198242
Took: 0.402196884155
Took: 0.398077964783
Took: 0.401179075241
Took: 0.40417098999

$ pypy-c --jit trace_limit=60000 bench.py
Took: 0.645992040634
Took: 0.284580945969
Took: 0.285857915878
Took: 0.282681941986
Took: 0.283298015594

----------
status: chatting -> resolved

________________________________________
PyPy bug tracker <tracker at bugs.pypy.org>
<https://bugs.pypy.org/issue839>
________________________________________