Re: Huge performance drop when using prepared statement

On 08/12/2007, Michael Dunn <[email protected]> wrote:
> I have no answers for this, but I did test it and found the same
> behaviour (I had to change "import pysqlite ..." to "from sqlite3
> import dbapi2 as sqlite", so I must be running a different version
> too). I'm very curious -- any ideas?

Then you are probably using pysqlite which comes with Python 2.5.  You
could also have written
  import sqlite3 as sqlite

The version of pysqlite which comes with Python 2.5 is for me
  pysqlite 2.3.2, sqlite 3.3.4

I tested the query also with the latest available pysqlite module,
which requires the import statement found in my script.
  pysqlite 2.4.0, sqlite 3.5.2

I wonder if this is a problem of pysqlite or sqlite itself.

Kind regards,
Markus