On 09/12/2007, Kees Nuyt <[EMAIL PROTECTED]> wrote:
> 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)?
No, the extra comma is necessary to make ('hui*',) a tuple, however
this is totally unrelated to the problem.
Markus
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
