[Owncloud] SQL Statements inside owncloud

[Thomas Müller]

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