Hi all,
I see a strange behavior on TG,
every time TG access to DB to populates a paginateGrid,
I see, in the log, the following query repeated more times:
--------------------------------------------------------------------------------------------------------------------------------------
SELECT visit.visit_key AS visit_visit_key, visit.expiry AS visit_expiry,
visit.created AS visit_created
FROM visit
WHERE visit.visit_key = %(visit_visit_key)s ORDER BY visit.visit_key
{'visit_visit_key': '423bdf8b81fd266e16ee31c7d0c9da5e79e43c7f'}
Retrieving identity for visit: 423bdf8b81fd266e16ee31c7d0c9da5e79e43c7f
Identity is available...
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_identity_visit_key)s ORDER BY
visit_identity.visit_key
LIMIT 1
{'visit_identity_visit_key': '423bdf8b81fd266e16ee31c7d0c9da5e79e43c7f'}
SELECT user.password AS user_password, user.logname AS user_logname,
anon_a2d6.codice AS anon_a2d6_codice, anon_a2d6.descrizione AS
anon_a2d6_descrizione, anon_a2d6.group_id AS anon_a2d6_group_id,
user.data_inizio AS user_data_inizio, user.data_fine AS user_data_fine,
user.id AS user_id, user.id_anagrafica AS user_id_anagrafica,
anon_f3fb.tipo_persona AS anon_f3fb_tipo_persona, anon_f3fb.id AS
anon_f3fb_id, anon_f3fb.id_comune AS anon_f3fb_id_comune,
anon_f3fb.cod_professione AS anon_f3fb_cod_professione,
anon_f3fb.dato_fiscale AS anon_f3fb_dato_fiscale, anon_f3fb.localita AS
anon_f3fb_localita, anon_f3fb.telefono AS anon_f3fb_telefono,
anon_f3fb.email AS anon_f3fb_email, anon_f3fb.nome AS anon_f3fb_nome,
anon_f3fb.tipo AS anon_f3fb_tipo, anon_f3fb.cod_titolo_studio AS
anon_f3fb_cod_titolo_studio, anon_f3fb.indirizzo AS anon_f3fb_indirizzo,
anon_f3fb.id_precedente AS anon_f3fb_id_precedente,
anon_f3fb.cod_nazione_nascita AS anon_f3fb_cod_nazione_nascita,
anon_f3fb.cod_cittadinanza AS anon_f3fb_cod_cittadinanza,
anon_f3fb.id_comune_nascita AS anon_f3fb_id_comune_nascita,
anon_f3fb.stato_record AS anon_f3fb_stato_record, anon_f3fb.id_user AS
anon_f3fb_id_user, anon_f3fb.cap AS anon_f3fb_cap,
anon_f3fb.ts_ultima_modifica AS anon_f3fb_ts_ultima_modifica,
anon_f3fb.data_nascita AS anon_f3fb_data_nascita
FROM user LEFT OUTER JOIN tg_group AS anon_e91a ON user.id =
anon_e91a.id_user LEFT OUTER JOIN role AS anon_a2d6 ON anon_a2d6.codice
= anon_e91a.cod_role LEFT OUTER JOIN anagrafica AS anon_f3fb ON
anon_f3fb.id = user.id_anagrafica
WHERE user.id = %(user_id)s ORDER BY user.id, anon_e91a.id, anon_f3fb.id
{'user_id': 1695}
------------------------------------------------------------------------------------------------------------------------------------
I would like ask if there's a way to change this behavior.
My TG version is 1.0.3 and SA 0.3.10
Thank you very much for any help.
j
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" 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/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
