Here are some real great tips that I have found. Please post any tips that you think may be useful. If you have the source, please post that as well.
- The Mandatory Access Control List feature introduced in 5.3 may cause performance issues, if a user is part of a lot of groups. The SQL generated from this can be significantly inefficient. There is a macl_security_disabled setting in dm_docbase_config object. By setting it to TRUE, the MACL security features are disabled and the inefficient part of the SQL is elimated. If you do not plan to use MACL, this is one way to improve performance. Source: Support Forums.