Re: [pysqlite] [ANN] pysqlite 2.5.1

Hi,

I managed to get pysqlite to compile statically using VS 2008:

http://xile.org/le/temp/pysqlite-2.5.1.win32-py2.6.exe

pysqlite: 2.5.1 -- SQLite: 3.6.6.1
1.10696983136

The statically linked _sqlite.pyd is about 448 kB in size.


On Tue, Nov 25, 2008 at 3:04 PM, Markus Gritsch <[email protected]> wrote:
> 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
>>
>