[Owncloud] SQL Statements inside owncloud

[Patrick Heller]

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

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