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

dave b tracker at bugs.pypy.org
Sun Aug 21 10:12:05 CEST 2011


New submission from dave b <db.pub.mail+pypy at gmail.com>:

So I decided to download and see what all the "fuss" was about the awesome! pypy.
I was disappoint :( 
Unfortunately, in pypy 1.6 on an amd64 machine there is a bunch of slowness one
hits when running code that does "a fair amount" of sqlite insertion (even when
using executemany). 

Here is some cprofile output --> 

   ncalls  tottime  percall  cumtime  percall filename:lineno(function)
  1697987    4.790    0.000    8.634    0.000
/home/user/pypy/pypy-1.6/lib_pypy/_ctypes/function.py:350(_call_funcptr)
  1018764    3.154    0.000    3.966    0.000
/home/user/pypy/pypy-1.6/lib_pypy/_sqlite3.py:936(_check_decodable)
  1018764    1.225    0.000   11.250    0.000
/home/user/pypy/pypy-1.6/lib_pypy/_sqlite3.py:947(set_param)
  1697985    1.016    0.000    1.830    0.000
/home/user/pypy/pypy-1.6/lib_pypy/_ctypes/function.py:592(_build_result)



I am not sure what the point of the "_check_decodable" method is :P so I just
made it return true :P (nothing broke ^ ^  but I didn't run any tests either ;) ).
The total 4.790 seconds spent in _call_funcptr is _way_ to much.

Cpython is taking pypy for a walk around the block (many times :P ) ... in my
use case.

----------
messages: 2996
nosy: daveb, pypy-issue
priority: bug
status: unread
title: Sqlite in pypy 1.6 on amd64 is very slow :)

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


More information about the pypy-issue mailing list