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@owncloud.org > http://mailman.owncloud.org/mailman/listinfo/devel
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Devel mailing list Devel@owncloud.org http://mailman.owncloud.org/mailman/listinfo/devel