I'm using the DatabaseServerLoginModule for authentication. I find that with
every web page request (for an already authorized user) the server queries
twice the database. I expected the users info to be cached, or at least to
not ask again for an already authorized user, but the database log shows
this for each web page requested. This degrades performance a lot.
48 Init DB myDatabase
48 Query SHOW VARIABLES
48 Query SET autocommit=0
48 Query SELECT PASSWORD AS Password FROM USUARIO WHERE
ID='jbrinquis'
48 Query rollback
48 Query SELECT ROLE AS Role, 'Roles' AS RoleGroup FROM ROLE
WHERE PRI_ID = 'jbrinquis'
48 Query rollback
48 Query SELECT PASSWORD AS Password FROM USUARIO WHERE
ID='jbrinquis'
48 Query rollback
48 Query SELECT ROLE AS Role, 'Roles' AS RoleGroup FROM ROLE
WHERE PRI_ID = 'jbrinquis'
48 Query rollback
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
