|
MySQL has a slow queries feature which is accessible via a log or at the command line. Please read the MySQL manual page to enable this feature.
Using the information in MySQL's chapter on optimization, look for places where indexes may improve the database access speed. Add an index, then re-test. If you think you've found an improved indexing scheme, please open a tracker item on dev.tiki.org.
In tiki-admin.php?page=general, you can activate Log SQL and set Log queries using more than (seconds):
|