[Owncloud] SQL Statements inside owncloud

[Patrick Heller]

How can i send a pull request?

I opend a issue but i can't open pull request.

Best Regards

Patrick
Am 08.03.2013 um 09:38 schrieb Thomas Müller <thomas.mueller at tmit.eu>:

> 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
> Owncloud at kde.org
> https://mail.kde.org/mailman/listinfo/owncloud