Dear all, Actually I answered my own question : the session engine sets up an application processor which interacts with the store at every request (including JS/IMG/CSS since I use a web.py controller for them).
I'm going to post a recipe to avoid that in another thread. Cheers Franck On Fri, Jan 14, 2011 at 1:06 AM, Franck <[email protected]> wrote: > Dear all, > > I'm using web.py for the website I'm currently developing, and I chose to > rely on DBStore-managed sessions : > > db = web.database(dbn='sqlite', db='...') > store = web.session.DBStore(db, 'sessions') > session = web.session.Session(app, store, {'is_logged': False, > 'user' : None}) > > I'm also using a "public" controller to handle JS/IMG/CSS files : > > '/(?:img|js|css)/.*', 'app.controllers.public.Public' > > The problem is, when a single page is loaded through the framework, loads > of SQL are actually issued to SELECT/UPDATE the user session (see sample log > below for one single page call). > > How could I reduce the number of SQL requests issued ? > Is there a way to tweak the session module ? > > Moreover, I've created my own DBStore module to make it > SQLAlchemy-compatible and a lot of COMMITS are going to be issued all the > time. > > Thanks a lot ! > Franck > > > > http://0.0.0.0:8080/ > [ > 0.0 (1): DELETE FROM sessions WHERE '2011-01-13T00:53:00.609000' > atime > 0.0 (2): SELECT * FROM sessions WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.0 (3): SELECT * FROM sessions WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.0 (4): UPDATE sessions SET atime = '2011-01-14T00:53:00.625000' WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.0 (5): SELECT * FROM sessions WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.02 (6): UPDATE sessions SET data = > 'KGRwMQpTJ2lzX2xvZ2dlZCcKcDIKSTAxCnNTJ2lwJwpwMwpWMTI3LjAuMC4xCnA0CnNTJ3VzZXJf\naWQnCnA1CkkyCnNTJ3VzZXInCnA2Ck5zUydzZXNzaW9uX2lkJwpwNwpTJ2FiOGZiYzg4ZDIxYjJh\nMGNjMmM0NWI1ZTIxY2NhMjJlMjc1ZmNjNjAnCnA4CnMu\n' > WHERE session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > > 127.0.0.1:2796 - - [14/Jan/2011 00:53:01] "HTTP/1.1 GET /tournament/3" - > 200 OK > > 0.0 (1): SELECT * FROM sessions WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.0 (2): SELECT * FROM sessions WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.0 (1): SELECT * FROM sessions WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.0 (2): SELECT * FROM sessions WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.02 (1): SELECT * FROM sessions WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.0 (2): SELECT * FROM sessions WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.06 (3): UPDATE sessions SET atime = '2011-01-14T00:53:01.187000' WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.0 (4): SELECT * FROM sessions WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.0 (5): UPDATE sessions SET data = > 'KGRwMQpTJ2lzX2xvZ2dlZCcKcDIKSTAxCnNTJ2lwJwpwMwpWMTI3LjAuMC4xCnA0CnNTJ3VzZXJf\naWQnCnA1CkkyCnNTJ3VzZXInCnA2Ck5zUydzZXNzaW9uX2lkJwpwNwpTJ2FiOGZiYzg4ZDIxYjJh\nMGNjMmM0NWI1ZTIxY2NhMjJlMjc1ZmNjNjAnCnA4CnMu\n' > WHERE session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > > 127.0.0.1:2797 - - [14/Jan/2011 00:53:01] "HTTP/1.1 GET > /js/jquery-1.3.2.js" - 200 OK > > 0.31 (3): UPDATE sessions SET atime = '2011-01-14T00:53:01.218000' WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.0 (4): SELECT * FROM sessions WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.02 (5): UPDATE sessions SET data = > 'KGRwMQpTJ2lzX2xvZ2dlZCcKcDIKSTAxCnNTJ2lwJwpwMwpWMTI3LjAuMC4xCnA0CnNTJ3VzZXJf\naWQnCnA1CkkyCnNTJ3VzZXInCnA2Ck5zUydzZXNzaW9uX2lkJwpwNwpTJ2FiOGZiYzg4ZDIxYjJh\nMGNjMmM0NWI1ZTIxY2NhMjJlMjc1ZmNjNjAnCnA4CnMu\n' > WHERE session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > > 127.0.0.1:2798 - - [14/Jan/2011 00:53:01] "HTTP/1.1 GET /js/locals.js" - > 200 OK > > 0.63 (3): UPDATE sessions SET atime = '2011-01-14T00:53:01.250000' WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.0 (4): SELECT * FROM sessions WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.0 (5): UPDATE sessions SET data = > 'KGRwMQpTJ2lzX2xvZ2dlZCcKcDIKSTAxCnNTJ2lwJwpwMwpWMTI3LjAuMC4xCnA0CnNTJ3VzZXJf\naWQnCnA1CkkyCnNTJ3VzZXInCnA2Ck5zUydzZXNzaW9uX2lkJwpwNwpTJ2FiOGZiYzg4ZDIxYjJh\nMGNjMmM0NWI1ZTIxY2NhMjJlMjc1ZmNjNjAnCnA4CnMu\n' > WHERE session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > > 127.0.0.1:2799 - - [14/Jan/2011 00:53:02] "HTTP/1.1 GET /css/defaults.css" > - 200 OK > 0.0 (1): SELECT * FROM sessions WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.0 (2): SELECT * FROM sessions WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.0 (1): SELECT * FROM sessions WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.0 (2): SELECT * FROM sessions WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.0 (1): SELECT * FROM sessions WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.0 (2): SELECT * FROM sessions WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60'0.05 (3): UPDATE > sessions SET atime = '2011-01-14T00:53:02.281000' WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > > 0.0 (4): SELECT * FROM sessions WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > > 0.0 (5): UPDATE sessions SET data = > 'KGRwMQpTJ2lzX2xvZ2dlZCcKcDIKSTAxCnNTJ2lwJwpwMwpWMTI3LjAuMC4xCnA0CnNTJ3VzZXJf\naWQnCnA1CkkyCnNTJ3VzZXInCnA2Ck5zUydzZXNzaW9uX2lkJwpwNwpTJ2FiOGZiYzg4ZDIxYjJh\nMGNjMmM0NWI1ZTIxY2NhMjJlMjc1ZmNjNjAnCnA4CnMu\n' > WHERE session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 127.0.0.1:2796 - - [14/Jan/2011 00:53:02] "HTTP/1.1 GET /img/accept.png" - > 200 OK > > 0.22 (3): UPDATE sessions SET atime = '2011-01-14T00:53:02.281000' WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.0 (4): SELECT * FROM sessions WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.0 (5): UPDATE sessions SET data = > 'KGRwMQpTJ2lzX2xvZ2dlZCcKcDIKSTAxCnNTJ2lwJwpwMwpWMTI3LjAuMC4xCnA0CnNTJ3VzZXJf\naWQnCnA1CkkyCnNTJ3VzZXInCnA2Ck5zUydzZXNzaW9uX2lkJwpwNwpTJ2FiOGZiYzg4ZDIxYjJh\nMGNjMmM0NWI1ZTIxY2NhMjJlMjc1ZmNjNjAnCnA4CnMu\n' > WHERE session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > > 127.0.0.1:2797 - - [14/Jan/2011 00:53:02] "HTTP/1.1 GET /img/refuse.png" - > 200 OK > > 0.34 (3): UPDATE sessions SET atime = '2011-01-14T00:53:02.312000' WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.0 (4): SELECT * FROM sessions WHERE > session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > 0.0 (5): UPDATE sessions SET data = > 'KGRwMQpTJ2lzX2xvZ2dlZCcKcDIKSTAxCnNTJ2lwJwpwMwpWMTI3LjAuMC4xCnA0CnNTJ3VzZXJf\naWQnCnA1CkkyCnNTJ3VzZXInCnA2Ck5zUydzZXNzaW9uX2lkJwpwNwpTJ2FiOGZiYzg4ZDIxYjJh\nMGNjMmM0NWI1ZTIxY2NhMjJlMjc1ZmNjNjAnCnA4CnMu\n' > WHERE session_id='ab8fbc88d21b2a0cc2c45b5e21cca22e275fcc60' > > > 127.0.0.1:2798 - - [14/Jan/2011 00:53:02] "HTTP/1.1 GET > /img/subscribe.png" - 200 OK > > -- You received this message because you are subscribed to the Google Groups "web.py" 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/webpy?hl=en.
