[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
  1018764    3.154    0.000    3.966    0.000
  1018764    1.225    0.000   11.250    0.000
  1697985    1.016    0.000    1.830    0.000

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>

More information about the pypy-issue mailing list