On Fri, Feb 12, 2010 at 10:13 AM, bruno desthuilliers
<[email protected]> 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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
