Hi, i ran into a simulair case as this message http://www.mail-archive.com/[EMAIL PROTECTED]/msg01646.html
where an index actually slows things down, because there are many rows matching the condition (where the other (indexed) condition only matches a few rows). In above mentioned letter you suggest to just drop the index, or concat the condition with an (empty) string (like: instead of "checked=0" use "checked||''='0' "). in my case, i need the index for another query.. well, i could consider to drop it but the fix is good enough for me.. i just like to mention that it would be a really cool feature to tell sqlite with index(es) not to use with something like 'IGNORE INDEX fieldname' or something.. also, maybe it is good idea to put this in the documentation (including above trick), but since it is a wiki i can guess the answer on that ;) regards, rene --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
