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 _________________________________________________________________________ ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
