Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Question about caching and queries
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Question about caching and queries
#20207
Question about caching and queries 12 Years, 9 Months ago Karma: 0
Hi,

I've been using ARI Ext Menu for some time and it's great product but I'm having some issues.

First thing, I've started doing some optimization on my site and Joomla debug mode states that enabling this module changed SQL queries number from 77 to 248. I admit, I have a lot of menu positions in this particular menu I'm displaying with ARI Ext menu but still it's kinda lot.

Second thing, enabling Joomla cache (XCache, 15minutes) did change the number of executed queries from 248 to 239 but further tests showed that the menu data that is pulled from DB isn't stored in Joomla cache at all. That is quite serious performance issue for me because I rarely change or add any menu positions and caching them would help a lot.

Is there any way of modifying this module to make it do less queries and to make it cacheable by Joomla?
Last Edit: 2011/10/03 00:36 By Raffael.
The administrator has disabled public write access.
 
#20208
Re: Question about caching and queries 12 Years, 9 Months ago Karma: 0
OK, I've managed to add caching to this module, it worked. Now I have 66 queries but the menu structure is totally destroyed (the menu is fully expanded all the time without styling).

I've read in few places that caching an expanding menu (with sublevels) usually ends very badly for the menu itself so I vahe to look somewhere else.

EDIT:
Quick check gave me an answer, js and css files for this module aren't loaded when cache is enabled.
Last Edit: 2011/10/03 01:29 By Raffael.
The administrator has disabled public write access.
 
#20212
Re: Question about caching and queries 12 Years, 9 Months ago Karma: 748
Hello,

About queries, the module doesn't do any SQL queries, it uses standard Joomla! API to work with menus. Joomla! loads menus structure once and uses Joomla! cache to optimize performance.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#20225
Re: Question about caching and queries 12 Years, 9 Months ago Karma: 0
I've read this guide: www.theartofjoomla.com/joomla-caching-explained.html and it states:

Notes for Module Developers

Module developers need to be aware that module caching is handled by the module renderer in the JDocumentRendererModule class. If the cache parameter is not provided, the module will never be cached regardless of the setting in Global Configuration. To allow a module to be cached, you must include the following parameter in the module's XML file:


Code:


<param name="cache" type="list" default="1" label="Caching" description="Select whether to cache the content of this module">
            <option value="1">Use global</option>
            <option value="0">No caching</option>
</param>



ARI Ext menu was lacking those lines, after adding them the module was cached in Joomla cache.
The administrator has disabled public write access.
 
Go to topPage: 1