Re: [pysqlite] [ANN] pysqlite 2.5.1

Gerhard Häring <[email protected]> Tue, 25 Nov 2008 14:55:48 +0100
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]>
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.