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 D. Richard Hipp [EMAIL PROTECTED] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
