Tickets :: Comment on [#10978] Issue viewing sessions when using MySQL/PDO Driver

* Your Email Address
* Spam protection	Enter the letters below: .__ \ /. ..___. . [ __ >< \ /[__ \| \| [_.// \ \/ [___\|/\\|
Comment	>>>> Without my patch the sessions page takes 9 seconds to open up, with >>>> my patch it takes under 1 second to open up. >>> >>> It's still the wrong patch. You need to find out where it's spending >>> the additional time. >> >> Ive narrowed down the problem. >> >> Horde/SessionHandler.php:177 >> It will hang on this call though to the DB read call but only if >> userid is equal to the currently logged on userid. This was confimed >> by putting a continue on a loop if id matched session_id; >> So maybe it seems that you are still holding a row readlock open on >> the session table of the user. > > This shouldn't happen. Can you track it further down into > SessionHandler/Storage/Sql.php inside the read() method? Is it > transactionStarted(), beginDbTransaction() or selectValue()?
Attachment
Watch this ticket