All, We've just recently upgraded to v2.10 for our Zimbra MTA's. Each MTA runs its own policy service and is connected to an centralized policyD database.
The issue I'm experiencing is we have approximately 146,000 policy members. After looking through some of the module code I have a better idea of what is going on. So, when a message is sent from the mailstore to the MTA, the MTA runs a SELECT query (in policies.pm) and returns an array of ALL the policy id's from the policy_members table. The query itself doesn't take long, it's the writing of the data and policyD taking it's time to match the source, e.g., even if the source id = 100, it will still continue parsing all of the array until it's complete. This is causing some serious delay of 20-30 seconds and I cannot see or find a way to improve this. Any help is appreciated!
_______________________________________________ Users mailing list [email protected] http://lists.policyd.org/mailman/listinfo/users_lists.policyd.org
