TOPIC: JC not caching menu and generated by router urls?

JC not caching menu and generated by router urls? 09 Nov 2015 13:30 #1520

  • gnsbud
  • gnsbud's Avatar
Hello,

I'm using JotCache 5.2 with Joomla 3.4.5 and Hikashop 2.6, I have large number of menu positions (over 5000), I'm visiting some page, next, if I revisit it, still page is loading 5-6 seconds, just like cache is not working (I can see in JotCache backend that this page is cached).
I have only two module positions excluded. In Joomla global config I run "System analyze" to check why it's taking so long: I have 185 database queries which are taking 0,4 second to proceed, so it's not database fault. I can see "Application: afterRoute" is running almost 3 seconds and "Application: afterRenderModule mod_menu (Menu)" is running over 2 seconds. I found out the "afterRoute" is running just after this query:
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM xx_menu AS m

  LEFT JOIN xx_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft
which is in /libraries/cms/menu/site.php around line 26.

My question: is there any reason why this part is not cached by JotCache?

Best regards,
Chris

Joomla version : 3.4
JotCache version : 5.2
site template: JV Flatize
system plugins : Hikashop 2.6
The administrator has disabled public write access.

JC not caching menu and generated by router urls? 12 Nov 2015 08:00 #1522

JotCache is not caching database requests but entire page content after page generation. Database requests as well as parts of content are mostly cached by appropriate extension (e.g. com_content, com_k2,..).
The administrator has disabled public write access.

JC not caching menu and generated by router urls? 12 Nov 2015 09:56 #1524

  • gnsbud
  • gnsbud's Avatar
Yes, I know, I didn't mean caching query. I was investigating more and I found out the most time is taken while decoding my menu positions params. Regardless, As you said, entire page content is cached, but while visiting page it looks like all db queries and php processes for generating that page are running just like without JotCache, I'm not a dev, but isn't this an issue? I have two websites using J 2.5 on the same server and everything is fine there, but for J 3.4 it seems it doesn't work properly.

Joomla version : 3.4
JotCache version : 5.2
site template: JV Flatize
system plugins :
The administrator has disabled public write access.
Time to create page: 0.242 seconds
We have 132 guests and no members online
Copyright © 2015 JotComponents
We have 132 guests and no members online
Copyright © 2017 JotComponents