Phoca Gallery Tree Caching

[rlopes]

As I've read here, the PGT has a performance issue for sites with lots of categories.
My site has more than 700 categories, and it's really slow.

I wonder, is there any way to cache it, so the server doesn't have to calculate everything on each user visit?

[Jan]

Hi, yes, displaying a tree can be server performance demanding as you cannot use pagination (you need to load all the categories - see more about this common problem in this forum)

One tip more: Check if this parameter:

Category Image Ordering - (Ordering Ascending | Ordering Descending | Title Ascending | Title Descending | Date Ascending | Date Descending | Id Ascending | Id Descending | Random | Special) If image will be displayed instead of Folder Icon in Category View, set which image will be selected (random, first, last, etc.)

Set Category Image ordering to "special" which means, no specific image ordering for category will be set (so this will save some sql queries)

https://www.phoca.cz/documents/2-phoca-g ... parameters

Jan

[rlopes]

Hi Jan, thank you very much for the tip, I just implemented it.

Still I wonder, is there any way to cache the Categories Tree? There's no need to recalculate everything on each page load. Instead of that, a static category list could be shown, and only regenerated once a new category is created.

[Jan]

Hi, in Joomla! 2.5 standard caching can be enabled but if this can help on your server, really no clue

Jan