It appears that setting SESSION_SAVE_EVERY_REQUEST = True is causing a new session to be created on each page access.
Background: I was doing some fiddling with a 'session browser' so that we can get an idea of how people are dealing with our new site. I set this config value because I wanted the timestamp to represent the most recent page fetch. (In another thread someone had a method for caching a dict of user/timestamp, but it would seem like this method should be quite usable.) After taking a week off from working on this, I couldn't figure out why formatting the output of Session.objects.all() was taking so long. I popped into phpMyAdmin and was amazed to find that we have over 290,000 sessions. This site normally gets about 4000 unique visitors a day, so this number was over the Moon. I limited my view to the most recent 200 sessions (so it would not crash) and was surprised to see that I had many sessions for a single user when I would have expected only one. For example, in less than a minute this user had at least 8 sessions created for her. 2008-01-04 13:44:59 kirsten d01ac014bdd9f4ec8eb9cd8e2186f6d8 2008-01-04 13:44:58 kirsten 0c06dc7c91e07b114ef1c4e7094f5de0 2008-01-04 13:44:48 kirsten db1997ac362a61355f6112d3ca145901 2008-01-04 13:44:44 kirsten be54f80dfe008b390c2afeb3eb9bd8c7 2008-01-04 13:44:36 kirsten a21147e03b2b73fc9112c4ba3fc4b1f5 2008-01-04 13:44:27 kirsten e50affc7642530c038b6331855fea006 2008-01-04 13:44:18 kirsten c95ba03513b916c47e516cb8ad483236 In phpMyAdmin I kept refreshing the Structure window on django_session and saw the number of rows going up by dozens at a time. Setting it to False + restart caused everything to calm down. I set it to True and sessions were again being created on each page. Set to False, and things were normal. I looked at contrib/sessions/*.py and the only place it referenced this value (middleware.py:process_response) looked completely reasonable. Does this ring a bell for anyone? I am running trunk/6688 on an RHEL 4 box, Python 2.5.1, Apache 2.0.52, mod_python 3.3.1. TIA, Peter --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
