Re: [pysqlite] [ANN] pysqlite 2.5.1

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.

Kind regards,
Markus


On Tue, Nov 25, 2008 at 12:23 PM, Gerhard Häring <[email protected]> wrote:
> This has changed:
>
> - Windows binaries are cross-compiled from Linux since release 2.5.0.
>   This introduced a performance degradation on Windows because no
>   optimization flags were used at all. The binaries are now built with
>   "-O2", which should fix the problem.
>
> - when building against the SQLite amalgamation "python setup.py
>   build_static" now always the latest SQLite amalgamation is fetched
>   instead of a hardcoded version in the setup.py file
>
> - got rid of setuptools; everything could be done with plain distutils
>   as well
>
> - got rid of call to sqlite3_complete in executescript(). This was
>   causing abysmal performance with large SQL scripts due to
>   exponential complexity of sqlite3_complete
>
> - build_static now includes the fulltext search extension; the Windows
>   binaries as well
>
> - build_docs now uses Sphinx to build the documentation (easy_install
>   sphinx first!)
> _______________________________________________
> list-pysqlite mailing list
> list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
> http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite
>