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.

Reply via email to