Re: [pysqlite] Performance degradation

Markus Gritsch wrote:
> On Tue, Nov 25, 2008 at 10:57 AM, Markus Gritsch <[email protected]> wrote:
>> Python 2.5:
>>  sqlite3.version: 2.3.2, sqlite3.sqlite_version: 3.3.4
>>  1.109 sec (avg. of 10 runs)
>>
>> Python 2.6:
>>  sqlite3.version: 2.4.1, sqlite3.sqlite_version: 3.5.9
>>  1.117 sec (avg. of 10 runs)
> 
> And when installing the mingw compiled pysqlite-2.5.0.win32-py2.6.exe
> the performance is considerably slower:
> 
> Python 2.6 with pysqlite-2.5.0.win32-py2.6.exe:
>   pysqlite: 2.5.0 -- SQLite: 3.6.1
>   1.711 sec (avg. of 10 runs)

Yes I just found out what's the cause for this. The cross-compilation 
does not set any compiler optimization settings, while Python distutils 
default is "-O2".

-- Gerhard