Adding Redis object cache to ZC for improved performance

ZC 1.5.6 Php 7.0, Nginx, MariaDb 10.x]

Hi folks,

We are going to need every bit of speed we can get. We aim to Large shop with over 250K products. Fortunately the public site is possible to make fast enough with numinix disk cache and mariadb query cache but the real problem is how to make the admin interface usable. Currently I have on my testsite about 240K products and categorylisting for example takes 25 seconds to load which is way too slow for updaters.

My idea is to incorporate Redis object cache to Zencart.

Wordpress all ready has a ready made plugin for that: https://wordpress.org/plugins/redis-cache/

Do you think this would be a feasible idea and how much work would be needed to port this plugin to zencart?

What is you're breakdown of categories and product within categories? I've heard of stores having that many product and not having that much lag time and not so sure that they've needed so many caching utilities.

Also, what steps have been taken to speed up the cart as recommended in the FAQ?

Hi,

perhaps I was bit unclear. The admin side product category listing is very slow, the public site is very much faster. I have disabled admin&public side category counts.

Again, is it 240K products in just one category? What's the arrangement between prods/cats? Is the "product category listing" slowdown just in drawing the list? Is it the list of categories? or the list of products within a category?