[Owncloud] SQL Statements inside owncloud

[Bernhard Posselt]

https://help.github.com/articles/be-social

On 03/08/2013 10:00 AM, Patrick Heller wrote:
> 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
> _______________________________________________
> Owncloud mailing list
> Owncloud at kde.org
> https://mail.kde.org/mailman/listinfo/owncloud

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/owncloud/attachments/20130308/fd3d3c44/attachment.html>