On 09/12/2007, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
>
> On Dec 9, 2007, at 5:27 AM, Kees Nuyt wrote:
>
> > 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*',))
> >
>
> SQLite will optimize a GLOB where the right parameter is
> a literal string. It will not do so if the right parameter is a
> parameter. http://www.sqlite.org/optoverview.html#like_opt
Hmm, if I replace 'hui*' by 'hu*'
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 ?
""", ('hu*',))
the query using bind variables also takes an unmeasurable short time period.
Markus
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
