Hi,
I encountered the following problem - login to my system generates a
lot of (+/- 45) queries
SELECT s.id AS s__id, s.name AS s__name, s.description AS
s__description, s.created_at AS s__created_at, s.updated_at AS
s__updated_at, s2.group_id AS s2__group_id, s2.permission_id AS
s2__permission_id, s2.created_at AS s2__created_at, s2.updated_at AS
s2__updated_at FROM sf_guard_permission s LEFT JOIN
sf_guard_group_permission s2 ON s.id = s2.permission_id WHERE
(s2.group_id IN ('1'))
SELECT s.id AS s__id, s.first_name AS s__first_name, s.last_name AS
s__last_name, s.email_address AS s__email_address, s.username AS
s__username, s.algorithm AS s__algorithm, s.salt AS s__salt,
s.password AS s__password, s.is_active AS s__is_active,
s.is_super_admin AS s__is_super_admin, s.last_login AS s__last_login,
s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM
sf_guard_user s WHERE (s.id = '2')
This is because the user has lots of groups and permissions. Someone
could advise where I should start looking for how to solve this
problem?
--
Best regards,
Michal
http://eventhorizon.pl/
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony developers" group.
To post to this group, send email to symfony-devs@googlegroups.com
To unsubscribe from this group, send email to
symfony-devs+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-devs?hl=en
