New SEF Advance with caching

[Saka]

A new version of SEF Advance has just been released. Version 4.8 introduces a new valuable feature: URL caching system!
When turned on, the URL cache will help reducing the load on sites with much content and high traffic.

Once calculated, the URLs are cached and this copy is used next time the URL conversion is called, instead of querying the database and calculating the URL again. This method has advantage of reducing queries to database dramatically, which should boost performance on large sites with DB load issues.

You can activate the caching in SEF Advance administration where you can also set the URL cache time (default 24 hours) and flush the cache.
Note that the cache should only be activated once you have finished designing your site and don't intend to change the menu structure, section and category names etc. If you edit something like that you will need to empty the cache.

Besides caching feature, SEF Advance 4.8 also includes some optimizations, fixes and debugging improvements.

This upgrade is again free for all customers, even them that purchased SEF Advance several years ago!

To upgrade from previous versions of SEF Advance uninstall the old version and install the new one through Joomla! / Mambo component installer. Note that this will delete your settings!

If you are upgrading from version 4.6 you can upgrade keeping your settings if you follow these instructions:
- Upload and replace all SEF Advance files on your server using FTP (./components/com_sef/* and ./administrator/components/com_sef/*).
- Execute the following commands on your mySQL database (you can use phpMyAdmin):

ALTER TABLE jos_sef_config ADD `cache` tinyint(1) NOT NULL default '0' AFTER `com_exception`;
ALTER TABLE jos_sef_config ADD `cachetime` int(11) NOT NULL default '0' AFTER `cache`;
UPDATE jos_sef_config SET `cache` = '0', `cachetime` = '86400' WHERE id = '1';

Current customers can use the automatic download page to update for free:
http://www.sakic.net/scripting/download/5/

New customers can order SEF Advance here:
http://www.sakic.net/products/sef_advance/

[Guenter]

Hello,

just tried to update to your caching version. First I tried only with copy files and do the SQL commands. All without any errors. If I started my Joomla, URLs looking nice, but unfortunelly I can not start your configuration menu in the Backend. I get on all an empty page. So I reinstalled it and installed it once again new with the Joomla installer. Again with the same problem in the Backend.

So now, I installed your Version 4.6.2 and it just working fine again.

My Joomla Version is 1.0.12.

Any idea on this?

PS. If you zip your files with the foldername, it would much be faster an easier to do an update.

regards
Günter

[Saka]

That's strange. Must be that installation hasn't been done properly.
Plese send me a mail with your admin password and FTP info and I will take a look and upgrade for you.

[anton]

It seems like is is working like a wet dream and this is one of the greatest components for joomla out there and the new feature is much needed for me.

[Gianni]

How can I check if the URL cache is working? Where are stored the URLs?

Bye.

[Saka]

@Günter: I installed it on your site and made the same configurations you had. It works fine. I haven't turned on the cache so you might want to that yourself.

[Saka]

How can I check if the URL cache is working? Where are stored the URLs?

If you turn on debugging in main Joomla! configuration you will be able to see number of executed database queries after the page has been displayed.
You will notice that the number of queries is much lower once the URL caching has been activated and URLs has been cached compared to when caching is turned off.

[Saka]

It seems like is is working like a wet dream and this is one of the greatest components for joomla out there and the new feature is much needed for me.

Thanks Anton!