[Owncloud] SQL Statements inside owncloud

[Jan-Christoph Borchardt]

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> <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 listOwncloud at kde.orghttps://mail.kde.org/mailman/listinfo/owncloud
>
>  _______________________________________________
> Owncloud mailing listOwncloud at kde.orghttps://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/4b79c249/attachment.html>