On Fri, Feb 12, 2010 at 10:13 AM, bruno desthuilliers <bruno.desthuilli...@gmail.com> wrote: > Anyway... an index on "archived" may do more harm than good. To be > really useful, an index needs to be as discriminating as possible
what i usually do is not an ('archived') index, but a ('archived','lastmsg_timestamp'), or something similar. that way the index as a whole is very discriminating, and quite efficient when asking for all non-archived records. -- Javier -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.