> Michael, > > Btw, even without partitioned tables, deleting by partition_tag value is > often faster than a traditional approach with joins, e.g.: > > DELETE FROM msgs WHERE partition_tag >= 30 AND partition_tag <= 46; > DELETE FROM msgrcpt WHERE partition_tag >= 30 AND partition_tag <= 46; > DELETE FROM quarantine WHERE partition_tag >= 30 AND partition_tag <= 46; > DELETE FROM maddr WHERE partition_tag >= 30 AND partition_tag <= 46;
One more thing I noticed: Since partition_tag is NOT part of, or an index in anything but maddr, #1, can't be included in mysql partitioning anyway, and even without mysql partitioning #2, without indexes on msgs msgrcpt, quarantine, mysql will just be doing a direct search on the tables, so, the README.sql-mysql should include index creation (at least?) on those rows. -- Michael Scheidell, CTO >|SECNAP Network Security Winner 2008 Network Products Guide Hot Companies FreeBSD SpamAssassin Ports maintainer _________________________________________________________________________ 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 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 AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
