I noticed this, but upon closer examination, it's doing a SQL prepare first. I don't know if you're seeing the same thing.
Since it's only being executed once, I don't know why the extra overhead of a SQL prepare but..../shrug. -Mike/Szii ----- Original Message ----- From: "Patrick Gibson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 28, 2004 11:28 AM Subject: Redundant database query? > I've got cyrus-imapd 2.2.8 setup to authenticate via a MySQL database. > I've enabled logging on the database while I'm setting things up, and > I've noticed that when I login, Cyrus runs the same query twice: > > 47 Connect [EMAIL PROTECTED] on RETRIX_TRANSITION > 47 Query START TRANSACTION > 47 Query select PASSWORD from USER_ACCOUNTS where > USERNAME='patrick' > 47 Query select PASSWORD from USER_ACCOUNTS where > USERNAME='patrick' > 47 Query COMMIT > > Any idea as to why this would be happening? > > I've looked through the sql.c module in the sasl source, but it doesn't > look like the problems originates there (though I could be wrong). Has > anyone else experienced this? > > This system will eventually have a lot of users, and I want to optimize > things as much as possible. > > Thanks, > > Patrick > > --- > patrick gibson > http://patrickgibson.com/ > > --- > Cyrus Home Page: http://asg.web.cmu.edu/cyrus > Cyrus Wiki/FAQ: http://cyruswiki.andrew.cmu.edu > List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html > > --- Cyrus Home Page: http://asg.web.cmu.edu/cyrus Cyrus Wiki/FAQ: http://cyruswiki.andrew.cmu.edu List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html
