On Thu, Feb 10, 2011 at 17:41, Thiago Coutinho <[email protected]> wrote: > Hello Devs, > > I use the Roundcube and I like so much, but in 0.5.1 version have a change in > rcube_user.php which causes problems in the users table with many records: > > SELECT * FROM users WHERE mail_host = '----' AND BINARY username = '---'; > > This query is too slow when we have more than 200000 records, because using > like this the index is not used. I did some tests and the best way is using > BINARY before the username(variable of login): > > SELECT * FROM users WHERE mail_host = '----' AND username = BINARY '---';
Indeed, moving the BINARY modifier makes mysql use the index again. Confirmed with EXPLAIN. This is now fixed in http://trac.roundcube.net/changeset/4532 Thanks a lot for reporting this! ~Thomas _______________________________________________ List info: http://lists.roundcube.net/dev/ BT/8f4f07cd
