Re: django_sessions table getting out of hand

2008-05-13 Thread Matt Davies
ahh Thanks Scott, I thought Arien was referring to me writing a script, when in fact there's one in source code already. Cheers --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this g

Re: django_sessions table getting out of hand

2008-05-09 Thread Scott Moonen
See http://www.djangoproject.com/documentation/sessions/#clearing-the-session-table -- Scott On Fri, May 9, 2008 at 10:24 AM, Matt Davies <[EMAIL PROTECTED]> wrote: > I got you Scott > > cron job it is > > I seem to remember Adrian putting a nippet up somewhere with the code > in(laxz I know),

Re: django_sessions table getting out of hand

2008-05-09 Thread Matt Davies
I got you Scott cron job it is I seem to remember Adrian putting a nippet up somewhere with the code in(laxz I know), anyone remember where it was? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" grou

Re: django_sessions table getting out of hand

2008-05-09 Thread Scott Moonen
Hi Matt. The reason folks don't prefer to do it within the application code is because it introduces a delay into rendering pages while the DELETE is executed -- even in cases where there is nothing to delete. By running the DELETE in a cron job you improve the performance of your page loads.

Re: django_sessions table getting out of hand

2008-05-09 Thread Matt Davies
Thanks for getting back to me Arien If that's what people are doing to sort it out then that's fine by me, I can write a cron job to run a script and everyone is happy. If anyone has a more elegant solution I'm all ears. I suppose I could overwrite sections of the middleware so that whenever a s

Re: django_sessions table getting out of hand

2008-05-09 Thread Matt Davies
Just a bit more information about how we're using the contrib.sessions The only mention of it I have in my site is in the settings file, we don't do anything else with it MIDDLEWARE_CLASSES = ( 'django.contrib.sessions.middleware.SessionMiddleware', ) Django source version is Schedule: normal

Re: django_sessions table getting out of hand

2008-05-09 Thread Arien
On Fri, May 9, 2008 at 7:28 AM, Matt Davies <[EMAIL PROTECTED]> wrote: > What's the best method of keeping the django_sessions table from growing so > large? Well, there's django/bin/daily_cleanup.py ;-) Arien --~--~-~--~~~---~--~~ You received this message beca

django_sessions table getting out of hand

2008-05-09 Thread Matt Davies
Hello everyone I know one of the uber genii who use this list will have a very easy solution to this one. What's the best method of keeping the django_sessions table from growing so large? I've just ran a delete from django_sessions where expire_date <= $yesterday to clear it out a little, clunk