Comment to The need for speed
-
I spent 5 minutes to turn on query log and get some real data. To keep the data clean, I blocked all web page access to my server other than from my IP address. I did one single load of the home page on my site. 3199 queries were logged. By eyeballing the data, i saw that many queries were being executed over and over again. For example
SELECT `tmo`.`value` AS `value` FROM `sys_options_mixes2options` AS `tmo` INNER JOIN `sys_options_mixes` AS `tm` ON `tmo`.`mix_id`=`tm`.`id` AND `tm`.`active`='1' WHERE `tmo`.`option`='bx_artificer_default_mix' LIMIT 1
This query was executed 136 times for one page load. Is this intentional?