[Owncloud] SQL Statements inside owncloud

[Alessandro Cosentino]

Sorry, I didn't want to nitpick, I was actually curious to know where
the index was.

Thanks Patrick :)

On Fri, Mar 8, 2013 at 3:43 PM, Patrick Heller <hellerpat at gmail.com> wrote:
> Sorry my fault!
>
> Here ist SQL Statement:
>
> CREATE INDEX userid_propertypath_index ON owncloudusr.oc_properties (userid,
> propertypath)
>
>
>
> Best Regards
>
> Patrick
>
>
> Am 08.03.2013 um 14:23 schrieb Alessandro Cosentino <cosenal at gmail.com>:
>
> @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
>
> _______________________________________________
> 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
>