[pypy-dev] CFFI speed results

[Eleytherios Stamatogiannakis]

We had a "bug" in our previous benchmark ("mspw_bench.sql"). The way it 
was written allowed SQLite to short-circuit column data retrieval, 
ending up with minimal exercising of the CFFI layer.

The attached query exercises CFFI as it should. We also checked its 
profiling characteristics, and it is a lot closer to what we are seen 
with our working query loads.

Below are timings when running it from inside mterm (so there is no 
import overhead):

CPython + APSW: 0 sec 956 msec
pypy + APSW: 8 sec 673 msec
pypy + MSPW: 2 sec 550 msec

Best regards.

lefteris.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mspw_bench.sql
Type: text/x-sql
Size: 122 bytes
Desc: not available
URL: <http://mail.python.org/pipermail/pypy-dev/attachments/20121217/74b64fdd/attachment.bin>