Home | FAQ | Manual | Ezmlm Manual Pages | Qmail Manual Pages | Readme | Upgrade | Downgrade

Optimizing MySQL for ezmlm - ezmlm-idx FAQ

Next: , Previous: Converting to and from and SQL database, Up: ezmlm support for SQL databases


5.7 Optimizing MySQL for ezmlm

5.7.1 Address SELECTs, additions, removals

ezmlm-idx-0.40 simplifies the SQL support and queries over ezmlm-idx-0.32 at the cost of dropping distributed sublist support. We have figured out a simpler way to support the latter, which hopefully will be incorporated into ezmlm in the future (written under contract).

With the simplification, the queries are very straight forward, and tuning is indicated only under extreme circumstances (very many very large and busy lists or constant addition/removal of many addresses).