#14231: Missing index on expire_date in Session model -------------------------------------+-------------------------------------- Reporter: joeri | Owner: nobody Status: new | Milestone: Component: django.contrib.sessions | Version: 1.2 Keywords: | Stage: Unreviewed Has_patch: 1 | -------------------------------------+-------------------------------------- We recently found that the Django session table, in a particular project setup, was not regularly cleaned. When we tried to do this manually (excluding recent entries), the select/delete action took like forever.
This was because there is no index defined on the "expire_date" field in the Session model and thus any action with a WHERE-clause on that field takes much longer than needed. Ruby had the same problem (long ago) and added an index on the expire_date field and I think Django should just do the same. Kudos to Frodo from Medid for noticing this. -- Ticket URL: <http://code.djangoproject.com/ticket/14231> Django <http://code.djangoproject.com/> The Web framework for perfectionists with deadlines. -- You received this message because you are subscribed to the Google Groups "Django updates" 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-updates?hl=en.
