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.
