Hi all,
I started monitoring the turbogears' access to the database and I see
there are too many access to user and visit_identity, and I can't
realize why.
Could someone please enlighten me?
To access page myform/index:
class Controller(object):
@tg.identity.require(tg.identity.Any(tg.identity.in_group("ADMIN"),
tg.identity.has_permission("myform")))
@tg.expose(template="kid:view.templates.search")
@tg.paginate(dynamic_limit='limit', var_name='grid_params',
default_order=default_order, max_limit=None)
def index(self, tg_errors=None, **data):
attrs = {}
if tg_errors:
tg.flash(....)
--------------
I see in the log:
127 accesses to table user
762 accesses to table visit_identity and
1 access to table visit
Why so many accesses to those tables?
What am doing wrong?
tg version 1.1.3
here is an extract of the log:
-----------------------------------
SELECT visit.visit_key AS visit_visit_key, visit.created AS
visit_created, visit.expiry AS visit_expiry
FROM visit
WHERE visit.visit_key = :param_1
{'param_1': '3f2193d6baa399b71e513afcdd7ef5f25da8242e'}
SELECT visit_identity_visit_key, visit_identity_user_id
FROM (SELECT visit_identity_visit_key, visit_identity_user_id, ROWNUM AS
ora_rn
FROM (SELECT visit_identity.visit_key AS visit_identity_visit_key,
visit_identity.user_id AS visit_identity_user_id
FROM visit_identity
WHERE visit_identity.visit_key = :visit_key_1)
WHERE ROWNUM <= :ROWNUM_1)
WHERE ora_rn > :ora_rn_1
{'ROWNUM_1': 1, 'visit_key_1':
'3f2193d6baa399b71e513afcdd7ef5f25da8242e', 'ora_rn_1': 0}
SELECT visit_identity_visit_key, visit_identity_user_id
FROM (SELECT visit_identity_visit_key, visit_identity_user_id, ROWNUM AS
ora_rn
FROM (SELECT visit_identity.visit_key AS visit_identity_visit_key,
visit_identity.user_id AS visit_identity_user_id
FROM visit_identity
WHERE visit_identity.visit_key = :visit_key_1)
WHERE ROWNUM <= :ROWNUM_1)
WHERE ora_rn > :ora_rn_1
{'ROWNUM_1': 1, 'visit_key_1':
'3f2193d6baa399b71e513afcdd7ef5f25da8242e', 'ora_rn_1': 0}
SELECT user.id AS user_id, user.logname AS user_logname, user.password
AS user_password, user.id_anagrafica AS user_id_anagrafica,
user.data_password AS user_data_password, user.data_inizio AS
user_data_inizio, user.data_fine AS user_data_fine, user.iscrizione_albo
AS user_iscrizione_albo, ruolo_1.codice AS ruolo_1_codice,
ruolo_1.descrizione AS ruolo_1_descrizione
FROM user LEFT OUTER JOIN acl acl_1 ON user.id = acl_1.id_user LEFT
OUTER JOIN ruolo ruolo_1 ON ruolo_1.codice = acl_1.cod_ruolo
WHERE user.id = :param_1
{'param_1': 1}
SELECT visit_identity_visit_key, visit_identity_user_id
FROM (SELECT visit_identity_visit_key, visit_identity_user_id, ROWNUM AS
ora_rn
FROM (SELECT visit_identity.visit_key AS visit_identity_visit_key,
visit_identity.user_id AS visit_identity_user_id
FROM visit_identity
WHERE visit_identity.visit_key = :visit_key_1)
WHERE ROWNUM <= :ROWNUM_1)
WHERE ora_rn > :ora_rn_1
{'ROWNUM_1': 1, 'visit_key_1':
'3f2193d6baa399b71e513afcdd7ef5f25da8242e', 'ora_rn_1': 0}
SELECT visit_identity_visit_key, visit_identity_user_id
FROM (SELECT visit_identity_visit_key, visit_identity_user_id, ROWNUM AS
ora_rn
FROM (SELECT visit_identity.visit_key AS visit_identity_visit_key,
visit_identity.user_id AS visit_identity_user_id
FROM visit_identity
WHERE visit_identity.visit_key = :visit_key_1)
WHERE ROWNUM <= :ROWNUM_1)
WHERE ora_rn > :ora_rn_1
{'ROWNUM_1': 1, 'visit_key_1':
'3f2193d6baa399b71e513afcdd7ef5f25da8242e', 'ora_rn_1': 0}
.....................
SELECT user.id AS user_id, user.logname AS user_logname, user.password
AS user_password, user.id_anagrafica AS user_id_anagrafica,
user.data_password AS user_data_password, user.data_inizio AS
user_data_inizio, user.data_fine AS user_data_fine, user.iscrizione_albo
AS user_iscrizione_albo, ruolo_1.codice AS ruolo_1_codice,
ruolo_1.descrizione AS ruolo_1_descrizione
FROM user LEFT OUTER JOIN acl acl_1 ON user.id = acl_1.id_user LEFT
OUTER JOIN ruolo ruolo_1 ON ruolo_1.codice = acl_1.cod_ruolo
WHERE user.id = :param_1
{'param_1': 1}
COMMIT
UPDATE visit SET expiry=:expiry WHERE visit.visit_key = :visit_key_1
{'visit_key_1': '3f2193d6baa399b71e513afcdd7ef5f25da8242e', 'expiry':
datetime.datetime(2013, 4, 26, 15, 27, 0, 955534)}
COMMIT
--
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/turbogears?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
