Urgent - Pageload Can Be Over 6 Seconds & Other Problems

Hello,

So after using the latest version 4.4.2 SP 1 we have stumbled across many bugs where we will inform you guys about right now.

1. Whenever products are in multiple categories page load gets affected by 4+ seconds of wait time.

Imagine this: I have a product that needs to show in the main category and a sub category of the main category. So the tree would look something like this:

Bicycle trailers --> Bicycle trailer 1

Subcategory bicycle trailers --> bicycle trailer 1

But somehow cscart cannot handle these request which can show HUGE, but with that I mean absolutely HUGE performance drops. It causes a page to load from just 1 second, all the way up to 6 seconds. --> the only thing affected here is the waiting time (TTFB), the actual page loading speed when the complete page is downloaded stays the same.

2. API performance is still very poor. http://forum.cs-cart.com/tracker/issue-6488-very-poor-api-performance/--> as discussed here

3. CSS code is not minimized. Please do this, its almost as easy as removing spaces (which can save in some cases over ~100 kb.

Planned for cs-cart 5.x

4. Redis is not performing well, whenever you have multiple cscart versions running on a server the cache files on redis will interfere and cause horrible issues (like links and carts showing other products, links redirecting you to the other store, and so on).

It is said that this can be fixed by defining the store_prefix in the config.local.php file. Thought THIS DOESNT SOLVE THE ISSUE. CUSTOMERS STILL CANT DO CERTAIN THINGS!

Please let me know how you guys solved these issues as they are VERY important to me

@oleg.gorshkov

Hello,

So after using the latest version 4.4.2 SP 1 we have stumbled across many bugs where we will inform you guys about right now.

1. Whenever products are in multiple categories page load gets affected by 4+ seconds of wait time.

Imagine this: I have a product that needs to show in the main category and a sub category of the main category. So the tree would look something like this:

Bicycle trailers --> Bicycle trailer 1

Subcategory bicycle trailers --> bicycle trailer 1

But somehow cscart cannot handle these request which can show HUGE, but with that I mean absolutely HUGE performance drops. It causes a page to load from just 1 second, all the way up to 6 seconds. --> the only thing affected here is the waiting time (TTFB), the actual page loading speed when the complete page is downloaded stays the same.

2. API performance is still very poor. http://forum.cs-cart.com/tracker/issue-6488-very-poor-api-performance/--> as discussed here

3. CSS code is not minimized. Please do this, its almost as easy as removing spaces (which can save in some cases over ~100 kb.

4. Redis is not performing well, whenever you have multiple cscart versions running on a server the cache files on redis will interfere and cause horrible issues (like links and carts showing other products, links redirecting you to the other store, and so on).

Please let me know how you guys solved these issues as they are VERY important to me

@oleg.gorshkov

We also provide speed and security optimization in our latest released hosting services. For more details please check http://cloudkul.com/

Please feel free to write us at support@webkul.com We will be glad to help you.

We also provide speed and security optimization in our latest released hosting services. For more details please check http://cloudkul.com/

Please feel free to write us at support@webkul.com We will be glad to help you.

Currently my workaround is to not have any products in shared categories. Furthermore the speed is just fine (400 ms response time and total page loading time is 1,2 seconds (DOM content load is in 0,8 seconds). So regarding that everything is fine. Except for the problem with shared categories, which is rather annoying.

Furthermore, we have a very good hosting service (which can be recommended https://www.true.nl/solutions/e-commerce/). Also, they respond to priority 1 tickets in under 8 minutes, which is very important to us.

As a final notice, our server is directly connected to the internet entry point in the netherlands (with 2 fibre optic cables).

Currently my workaround is to not have any products in shared categories. Furthermore the speed is just fine (400 ms response time and total page loading time is 1,2 seconds (DOM content load is in 0,8 seconds). So regarding that everything is fine. Except for the problem with shared categories, which is rather annoying.

Furthermore, we have a very good hosting service (which can be recommended https://www.true.nl/solutions/e-commerce/). Also, they respond to priority 1 tickets in under 8 minutes, which is very important to us.

As a final notice, our server is directly connected to the internet entry point in the netherlands (with 2 fibre optic cables).

Please check your pm.

Have you reviewed your DB to see if any tables need repair or optimization?

What you describe is not typical that I've seen.

When you say the categories are shared, among how many storefronts. What page(s) is showing the speed degradation?

I think to get anywhere you should start posting the issues and logs in more detail so people can help you do a diagnosis of the issues. There could be any number of things causing all of those 4 issues above. Could you post SQL query times and other data?

Hello,

To give you some more information here are my finding so far:

When you enable a product in a subcategory and share it in its main category the category page will show a HUGE performance degradation (you can test this for yourself, just add 20 products or so to a sub category and then add the main category aswell (with view products in subcategories ENABLED.

Furthermore, my server is absolutely fine, I have a dedicated server with 2 1000mbp/s fibreglass cables, 10 reserved IP's 16 GB of ECC non buffered memory and a intel Xeon E5-2667v3. (running 3 instances of cs.cart - latest version). Also it is using the latest php, mysql & nginx version. And to top it of it also has a cloudfront CDN set up. So I guess performance shouldnt be an issue.

I also ran a database check and this said that everything was fine. I also checked permissions and every other neccessary thing, but for now this has all been fine.

But the weird thing is that when I was on 4.3.9 this performance decrease wasnt there. But when we test it on every store it seems that this is the case.

Markhedley please provide which logs you do need to find some of these things out, but do mind our cache is cleared EVERY night, also the MySQL database is optimized EVERY night.

Hello,

So after using the latest version 4.4.2 SP 1 we have stumbled across many bugs where we will inform you guys about right now.

1. Whenever products are in multiple categories page load gets affected by 4+ seconds of wait time.

Imagine this: I have a product that needs to show in the main category and a sub category of the main category. So the tree would look something like this:

Bicycle trailers --> Bicycle trailer 1

Subcategory bicycle trailers --> bicycle trailer 1

But somehow cscart cannot handle these request which can show HUGE, but with that I mean absolutely HUGE performance drops. It causes a page to load from just 1 second, all the way up to 6 seconds. --> the only thing affected here is the waiting time (TTFB), the actual page loading speed when the complete page is downloaded stays the same.

2. API performance is still very poor. http://forum.cs-cart.com/tracker/issue-6488-very-poor-api-performance/--> as discussed here

3. CSS code is not minimized. Please do this, its almost as easy as removing spaces (which can save in some cases over ~100 kb.

4. Redis is not performing well, whenever you have multiple cscart versions running on a server the cache files on redis will interfere and cause horrible issues (like links and carts showing other products, links redirecting you to the other store, and so on).

Please let me know how you guys solved these issues as they are VERY important to me

@oleg.gorshkov

hello

why don't you post this redis issues to the bugtracker it seems like a bug which was in a other caching method

http://forum.cs-cart.com/tracker/project-1-cs-cart/

hello

why don't you post this redis issues to the bugtracker it seems like a bug which was in a other caching method

http://forum.cs-cart.com/tracker/project-1-cs-cart/

That has been done, but for so far I cant really seem to figure out what is causing this, but I'm working on it!

hello

why don't you post this redis issues to the bugtracker it seems like a bug which was in a other caching method

http://forum.cs-cart.com/tracker/project-1-cs-cart/

Found the code snippet which might prove my point for now:

    public function __construct($config)
    {
        $this->_config = array(
            'redis_server' => $config['cache_redis_server'],
            'store_prefix' => !empty($config['store_prefix']) ? $config['store_prefix'] : null,
            'global_ttl' => !empty($config['cache_redis_global_ttl']) ? $config['cache_redis_global_ttl'] : 0,
        );
    $this->host = $config['cache_redis_server'];

    if (strncmp($this->host, '/', 1) === 0) {
        $this->port = null;
    } else {
        $parsed = parse_url($this->host);

        if ($parsed && isset($parsed['host'], $parsed['port'])) {
            $this->host = $parsed['host'];
            $this->port = $parsed['port'];
        }
    }

    parent::__construct($config);

    if ($this->connect()) {
        return true;
    }

    return false;
}

As you can see it uses the store prefix only, but if you run multiple cs.cart versions that are exactly the same, and thus have the same store_prefix, then your stores wouldn't be able to store all of it.

(with building our stores we used a costumized version of cs.cart and used the same root for every store, so the only difference between our multiple stores are a few colours for our themes and the products, furthermore nothing else. Which means that the store_prefix is likely the same)

(it can btw also be the same as defined for the MySQL database, which could also cause the issue because everything is named cscart_)

hello

why don't you post this redis issues to the bugtracker it seems like a bug which was in a other caching method

http://forum.cs-cart.com/tracker/project-1-cs-cart/

I finally found the issue!

So in your config.local.php you can edit the store_prefix (which is defaulted to have no value, which can DEFINETELY be improved, but for so far everything is working glorious for now!

I finally found the issue!

So in your config.local.php you can edit the store_prefix (which is defaulted to have no value, which can DEFINETELY be improved, but for so far everything is working glorious for now!

Well in the end it hasn't been that glorious. It turns out that whenever you do have the store_prefix enabled you cant add anything to the cart! What is this nonsense!