On 7/6/10 6:16 PM, Nathan M wrote:
> On Tue, Jul 6, 2010 at 10:34 AM, Michael Scheidell<scheid...@secnap.net>
> wrote:
>
>> partition_tag is a key, yes use it, and DON'T use 'in' (as:
>> partition_tag in (18,19)
>> or partition_tag between, etc. some versions of mysql mess optimization up.
>>
>>
> I tried it out by adding the active (3) partition tags to the same
> query. The speed was virtually identical& still slow. When using
>
try with just ONE partition_tag. not multiple. if you use multiple,
the mysql optimizer breaks.
--
Michael Scheidell, CTO
Phone: 561-999-5000, x 1259
> *| *SECNAP Network Security Corporation
* Certified SNORT Integrator
* 2008-9 Hot Company Award Winner, World Executive Alliance
* Five-Star Partner Program 2009, VARBusiness
* Best in Email Security,2010: Network Products Guide
* King of Spam Filters, SC Magazine 2008
______________________________________________________________________
This email has been scanned and certified safe by SpammerTrap(r).
For Information please see http://www.secnap.com/products/spammertrap/
______________________________________________________________________
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
Please visit http://www.ijs.si/software/amavisd/ regularly
For administrativa requests please send email to rainer at openantivirus dot
org
