On Sun, 9 Dec 2007 10:55:16 +0100, "Markus Gritsch" <[EMAIL PROTECTED]> wrote:
>Hi, > >when using bind variables I get a huge performace drop compared to >using a plain string. The query is demonstrated in the attached file >"problematic_query.py". Problematic SELECT: > c.execute("""SELECT * FROM entry, word, word_entry WHERE > entry.id = word_entry.entry_id AND > word.id = word_entry.word_id AND > word.word GLOB ? > """, ('hui*',)) I must admit I never use Python, but, considering the docs in http://docs.python.org/lib/module-sqlite3.html, shouldn't the last line be: """, ('hui*')) (without the extra comma)? >The database used can be downloaded from > http://xile.org/le/prepared_statement.zip (1.75 MB) > >or generated by using the attached file "create_test_db.py". > >Kind regards, >Markus -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------