From: Michael S. <sch...@se...> - 2008-11-24 12:10:42
|
Mark: I am ccing you directly just in case, and since you are working on 2.6.2 RC, you might consider this. I can give you access to a box with the problem if you like. Bernd Probst wrote: > Hi, > > in my maddr table are about 400.000 recordsets. Im using mysql 5.0.x and > amavisd-new 2.6.1. > > I received an answer within 0.1 second. > > yes, I think specifically, it is a mysql 5.1.x issue. It looked fine with 5.0 also. Thank you for checking, this does, then look like a mysql 5.1 optimization issue. > I realized a different problem: the combination of order by and LIMIT does > not always list the last message. According to > http://dev.mysql.com/doc/refman/5.0/en/limit-optimization.html MySQL ends > sorting after - in this case - one recordset. There could exist newer > recordsets in the database. Since the penpal bonus score is exponentially > decreasing in time, it might be too low. > > then, MAYBE, the answer to both problems is a combination of changing the query (take out limit?) and have amavisd 2.6 just pop the first answer off the stack? -- Michael Scheidell, CTO Phone: 561-999-5000, x 1259 > *| *SECNAP Network Security Corporation * Certified SNORT Integrator * King of Spam Filters, SC Magazine 2008 * Information Security Award 2008, Info Security Products Guide * CRN Magazine Top 40 Emerging Security Vendors _________________________________________________________________________ This email has been scanned and certified safe by SpammerTrap(r). For Information please see http://www.spammertrap.com _________________________________________________________________________ |