Re: [pysqlite] [ANN] pysqlite 2.5.1

Python 2.5 with pysqlite-2.5.1.win32-py2.5.exe
  pysqlite: 2.5.1 -- SQLite: 3.6.2
  1.17517935939

Python 2.6 with pysqlite-2.5.1.win32-py2.6.exe
  pysqlite: 2.5.1 -- SQLite: 3.6.2
  1.15202999264

Same performance improvement here, but indeed more than twice as large
binaries compared to the ones produced by the MS compilers...


On Tue, Nov 25, 2008 at 2:55 PM, Gerhard Häring <[email protected]> wrote:
> Markus Gritsch wrote:
>> Python 2.5 with built-in sqlite3:
>>   pysqlite: 2.3.2 -- SQLite: 3.3.4
>>   1.11811187595
>>
>> Python 2.5 with pysqlite-2.5.1.win32-py2.5.exe
>>   pysqlite: 2.5.1 -- SQLite: 3.6.2
>>   1.41129352334
>>
>> Python 2.6 with built-in sqlite3:
>>   pysqlite: 2.4.1 -- SQLite: 3.5.9
>>   1.12796766768
>>
>> Python 2.6 with pysqlite-2.5.1.win32-py2.5.exe
>>   pysqlite: 2.5.1 -- SQLite: 3.6.2
>>   1.41452496057
>>
>> -O2 on mingw improved the situation but the MS compilers seem to
>> produce faster code.
>
> Can you try these binaries, please?
>
> http://oss.itsystementwicklung.de/download/pysqlite/2.5/2.5.1/opt/
>
> They're compiled with -O3, which unfortunately increases compile time
> and size of the .pyd file quite a lot (*). But I get 5.41 sec. instead
> of 7.19 seconds for the benchmark.
>
> -- Gerhard
>
> (*) I also tried -fomit-frame-pointer and -funroll-loops but they didn't
>  help so I went with just -O3.
> _______________________________________________
> list-pysqlite mailing list
> list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
> http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite
>