Thanks a lot for your analysis! Can I ask you to open a bug report - in case there is not yet any open: https://github.com/owncloud/core/issues?sort=created&state=open
Contributions are welcome as well - feel free to fix it and send us a pull request! ;-) THX, Tom Am Freitag, dem 08.03.2013 um 9:11 schrieb Patrick Heller: > Hi All, > did anybody has an overview about all select statement they are being used in > owncloud? > > > I take a look on my MYSQL Server and it seems that they are no indexes on the > tables! > > Example: > > owncloud use the following command: > > SELECT * FROM 'oc_properties' WHERE 'userid' = '<USERID>' AND 'propertypath' > = '<PATH>' > > it takes up to 2 seconds to execute this command! > > after I add: > > SELECT * FROM 'oc_properties' WHERE 'userid' = '<USERID>' AND 'propertypath' > = '<PATH>' > > it takes 0.2 seconds! > > I think there are a lot of SQL Statements what can be done much faster if SQL > indexes will be used! > > > Best Regards > > > Patrick Heller _______________________________________________ Owncloud mailing list [email protected] https://mail.kde.org/mailman/listinfo/owncloud
