Administrator Tips

Here are some useful tips for board administrators that have Contact List running on their forums. These will help you make the most of your Contact List installation and keep your forums easy to use.


Keep Your Database Slim and Trim
If your users delete a lot of people from their contact lists, you may want to periodically run an SQL optimize command on the database table used by Contact List. This command reclaims unused space that results from having a lot of table rows deleted and can speed up a forum greatly in some cases. Users of phpMyAdmin can do this easily through that script's provided interface. The exact method varies from version to version of phpMyAdmin, so it is up to you to figure out how to use this feature.

If you don't use or have phpMyAdmin, the optimize command would look something like this for MySQL databases:

Code:

There is a very useful hack called Optimize Database that can automate this procedure on MySQL databases.