Next: Maintenance of the MySQL database, Previous: Converting to and from and SQL database, Up: ezmlm support for SQL databases
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).