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

Arman Khalatyan arm2arm at gmail.com
Mon Jan 12 20:26:48 GMT 2015


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

***********************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.owncloud.org/pipermail/devel/attachments/20150112/92891a60/attachment-0001.html>


More information about the Devel mailing list