Well, at this current time the database queries are not cached through memcache, but you will still see a performance improvement by enabling some kind of memcache supported by ownCloud. I'd suggest using APCu (or plain APC for older PHP versions), which requires next to no configuration after it's been installed. In addition, enabling the asset pipeline will greatly speed up CSS and JS execution, if performance is what you are after.
Robin McCorkell On 12/01/2015 10:15 PM, Arman Khalatyan wrote: > 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 > <rmccork...@karoshi.org.uk <mailto:rmccork...@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@owncloud.org <mailto: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
