Hello,

Looking at debug and duplicated queries, I noticed that every instance of a module in a page, requests Joomla\CMS\Table\Table->load(), which in turn, generates all the queries associated with that call.

An example query that happens as a result of that, for example, is:

SELECT `t`.`id`
FROM `__tags` AS `t`
INNER JOIN `__contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)

But any other query that Joomla executes from Joomla\CMS\Table\Table->load() it's executed a duplicate amount of times per as many modules that are on the page. Actually this does not just apply to modules from AMM, but also per as many ReReplacer items as well.

Is there any way that you only call Joomla\CMS\Table\Table->load() once from the 1st instance of a module/ReReplacer found on the page, and the other modules/ReReplacer items don't do it, so that queries don't get duplicated?

Let me know, thanks!

I already tested this and see the stack trace, here is an example:



I see a duplicate of this one for every module on the page. Removing a module removes one duplicate. And so on. Same for ReReplacer items

Nice, I confirm it now cleaned up a lot of duplicate queries!

By comparison to before the update, it now removed 7 different sets of duplicate queries (so there were 6 more sets of queries in addition to the one I sampled above)

On a sample (heavy) page, it brought the query count from 558 to 426.

Great!