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 <[email protected]> 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 <[email protected]>: > > @Patrick: how does your first query differ from the second one? > > Alessandro > > On Fri, Mar 8, 2013 at 11:16 AM, Jan-Christoph Borchardt > <[email protected]> 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 <[email protected]> > 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 <[email protected]>: > > 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 > [email protected] > https://mail.kde.org/mailman/listinfo/owncloud > > _______________________________________________ > Owncloud mailing list > [email protected] > https://mail.kde.org/mailman/listinfo/owncloud > > > > _______________________________________________ > Owncloud mailing list > [email protected] > https://mail.kde.org/mailman/listinfo/owncloud > > > > _______________________________________________ > Owncloud mailing list > [email protected] > https://mail.kde.org/mailman/listinfo/owncloud > > _______________________________________________ > Owncloud mailing list > [email protected] > https://mail.kde.org/mailman/listinfo/owncloud > > > > _______________________________________________ > Owncloud mailing list > [email protected] > https://mail.kde.org/mailman/listinfo/owncloud > _______________________________________________ Owncloud mailing list [email protected] https://mail.kde.org/mailman/listinfo/owncloud
