Credentials are cached to avoid duplicate calls. File a bug report stating the JBoss version and the servlet container version.
xxxxxxxxxxxxxxxxxxxxxxxx Scott Stark Chief Technology Officer JBoss Group, LLC xxxxxxxxxxxxxxxxxxxxxxxx ----- Original Message ----- From: "Ignacio Coloma" <[EMAIL PROTECTED]> To: "Jboss Development" <[EMAIL PROTECTED]> Sent: Sunday, December 30, 2001 4:29 AM Subject: [JBoss-dev] performance of DatabaseServerLoginModule > 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
