Comment to 'The need for speed'
Comment to The need for speed

  • 3461 sql queries beside everything else! No wonder my cell phone heats up. Haha. Seems impossible to need so many data points.

    No doubt the Devs try to reduce unnecessary code at every step. Wonder how other CMS's compare.

    Thank you for the reply.

    • G

      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?