This query loads all the table (module_vars) in the memory.
Rows in this table may vary from about 400 to more then 1000 from site to site. Each row can contain simple values, but often in module variables are stored big missives of data, for example HTML blocks, or modules, which use module variables to store data.
In most cases only one module is used to generate current page (pplus core variables). So, this approach can be optimized.
Currently variables for all module and pseudo modules are loaded when Zikula core initializes. This happens in line: https://github.com/zikula/core/blob/1.4/src/lib/util/ModUtil.php#L117
This query loads all the table (
module_vars
) in the memory.Rows in this table may vary from about 400 to more then 1000 from site to site. Each row can contain simple values, but often in module variables are stored big missives of data, for example HTML blocks, or modules, which use module variables to store data.
In most cases only one module is used to generate current page (pplus core variables). So, this approach can be optimized.
What do you think?