[owncloud-devel] Is it possible to offload mysql-server some unnecessary queries by caching?

Arman Khalatyan arm2arm at gmail.com
Mon Jan 12 22:15:52 GMT 2015


Thank you for the good news,
So If I enable memcache OC7 will go faster?:)

***********************************************************

Dr. Arman Khalatyan eScience -SuperComputing Leibniz-Institut für
Astrophysik Potsdam (AIP) An der Sternwarte 16, 14482 Potsdam, Germany

***********************************************************


On Mon, Jan 12, 2015 at 10:57 PM, Robin McCorkell <rmccorkell at karoshi.org.uk
> wrote:

> Hi Arman,
>
> Yes, it is certainly possible to do this, by means of memcache (see
> `\OC::$server->getMemCacheFactory()`). Some parts of oC use the
> memcache, in fact, me and Lukas were recently hooking it up to new
> things like finding binary paths
> (https://github.com/owncloud/core/pull/13192) or normalizing paths
> (https://github.com/owncloud/core/pull/13235). I'm profiling using
> XDebug to find slow code paths, but I'll have a look at database queries
> and see what I can do.
>
> Robin McCorkell
> The Linux Schools Project
>
> On 12/01/2015 8:26 PM, Arman Khalatyan wrote:
> > Hi,
> > I noticed that same query set is fired on every reload of main login
> page:
> > OC7 trying every time to ask DB is app enabled or not to generate
> > css/js etc?
> > Are there way to enable caching for those unnecessary queries? Because
> > apps info is mostly static data.
> >
> >
> > ....
> >                   186 Query     SELECT `configvalue`, `appid` FROM
> > `oc_appconfig` WHERE `configkey` = 'enabled'
> >                   186 Query     SELECT `configvalue`, `configkey` FROM
> > `oc_appconfig` WHERE `appid` = 'core'
> >                   186 Query     SELECT `configvalue`, `appid` FROM
> > `oc_appconfig` WHERE `configkey` = 'enabled'
> >                   186 Query     SELECT `configvalue`, `appid` FROM
> > `oc_appconfig` WHERE `configkey` = 'enabled'
> >                   186 Query     SELECT `configvalue`, `appid` FROM
> > `oc_appconfig` WHERE `configkey` = 'enabled'
> >                   186 Query     SELECT `configvalue`, `appid` FROM
> > `oc_appconfig` WHERE `configkey` = 'enabled'
> >                   186 Query     SELECT `configvalue`, `appid` FROM
> > `oc_appconfig` WHERE `configkey` = 'enabled'
> > ......
> >
> > ***********************************************************
> >  Dr. Arman Khalatyan              eScience -SuperComputing
> >  Leibniz-Institut für Astrophysik Potsdam (AIP)
> >  An der Sternwarte 16, 14482 Potsdam, Germany
> > ***********************************************************
> >
> >
> > _______________________________________________
> > Devel mailing list
> > Devel at owncloud.org
> > http://mailman.owncloud.org/mailman/listinfo/devel
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.owncloud.org/pipermail/devel/attachments/20150112/44197c49/attachment.html>


More information about the Devel mailing list