evert/SabreDAV — pull request #24 by PHPGangsta (2012-03-29 13:27:23+00:00)
Title: added mysql INDEX to calendarobject and calendar table

I activated MySQL log-queries-not-using-indexes and then did some things with Apple iCal and my own client. Then checking the slow query log file for queries that are not using an INDEX and added them for these calendar queries.

Maybe you can do the same for CardDAV, normal WebDAV, the build in PDO authentication (I'm using another authentication method). There should be some missing INDEXes in the other tables.

I'm not sure about SQLite and Postgres, if and how Indexes can be added there.

http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_log-queries-not-using-indexes