[Owncloud] SQL Statements inside owncloud

Alessandro Cosentino cosenal at gmail.com
Fri Mar 8 13:23:06 UTC 2013


@Patrick: how does your first query differ from the second one?

Alessandro

On Fri, Mar 8, 2013 at 11:16 AM, Jan-Christoph Borchardt
<hey at jancborchardt.net> wrote:
> More specifically on pull requests:
> https://help.github.com/articles/using-pull-requests
>
> Short: You fork the repo, do the fix in your fork, and the push »Pull
> request« in the top right of your repo. Then you describe your fixes and we
> will review it. Cheers!
>
>
> On Fri, Mar 8, 2013 at 10:14 AM, Bernhard Posselt <nukeawhale at gmail.com>
> wrote:
>>
>> 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
>>
>>
>>
>> _______________________________________________
>> 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
>



More information about the Owncloud mailing list