owncloud/core — pull request #2191 by PatrickHeller (2013-03-08 10:50:56+00:00)
Title: Additional index for properties table

I take a look on my MYSQL Server and it seems that there is no index on
the oc_poperties table!

owncloud use the following command:

SELECT * FROM 'oc_properties' WHERE 'userid' = '' AND
'propertypath' = ''

it takes up to 2 seconds to execute this command!

after I add:

CREATE INDEX USER_PATH ON owncloudusr.oc_properties (userid,
propertypath)

it takes 0.2 seconds!

Best Regards

Patrick Heller