539096 - More than 1 Session query per request

Status: RESOLVED INVALID

(addons.mozilla.org Graveyard :: Public Pages, defect)

Description

[Jeff Balogh (:jbalogh)]

I started printing out all the queries for something else and noticed that there are 11 queries for django_session in one request.  Can we fix this easily?

Comment 1

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

Yeah, did you just find them in the mysql query log?

I think we can probably put the sessions entirely in cache.

Comment 2

[Jeff Balogh (:jbalogh)]

I think this is coming from contrib/sessions/backends/db.py:load().  It doesn't show up in the debug toolbar, but it's hitting mysqldb.cursor.execute().

This is the query: 

SELECT `django_session`.`session_key`, `django_session`.`session_data`, `django_session`.`expire_date` FROM `django_session` WHERE (`django_session`.`session_key` = '21ada175b4ad22f011e6ee35df7e635d'  AND `django_session`.`expire_date` > '2010-01-11 14:56:39' )

Comment 3

[Jeff Balogh (:jbalogh)]

After some collaborative debugging, we discovered that I was seeing a session query for each media request.  That only happens in dev mode when django is serving media, so it's not a big deal.