It would be even better if SQLite could do a better job at optimizing the index searches.
__ Raymond Irving --- rene <[EMAIL PROTECTED]> wrote: > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]