Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Urgent - Pageload Can Be Over 6 Seconds & Other Problems Rate Topic   - - - - -

 
  • poppedweb
  • Authorized Reseller
  • Members
  • Join Date: 02-Aug 16
  • 553 posts

Posted 09 January 2017 - 02:51 PM #1

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...pi-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 


Edited by poppedweb, 26 January 2017 - 07:52 PM.

PoppedWeb | sales@poppedweb.com | https://poppedweb.com
TurnKey Website Design | Add-Ons | Performance Audits | Dedicated Server Management
24/7 Support | Response within an hour (during working hours).

 
  • webkul
  • Senior Member
  • Members
  • Join Date: 04-Dec 14
  • 391 posts

Posted 09 January 2017 - 04:02 PM #2

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...pi-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.


Webkul Software Pvt. Ltd | support@webkul.com | Offers you :

CS-Cart Addons | Mobikul Mobile App Builder for CS-Cart | AWS Hosting and Speed Optimization Services

Get A Free Quote 


 
  • poppedweb
  • Authorized Reseller
  • Members
  • Join Date: 02-Aug 16
  • 553 posts

Posted 09 January 2017 - 04:11 PM #3

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/.../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).


PoppedWeb | sales@poppedweb.com | https://poppedweb.com
TurnKey Website Design | Add-Ons | Performance Audits | Dedicated Server Management
24/7 Support | Response within an hour (during working hours).

 
  • webkul
  • Senior Member
  • Members
  • Join Date: 04-Dec 14
  • 391 posts

Posted 10 January 2017 - 01:44 PM #4

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/.../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.


Webkul Software Pvt. Ltd | support@webkul.com | Offers you :

CS-Cart Addons | Mobikul Mobile App Builder for CS-Cart | AWS Hosting and Speed Optimization Services

Get A Free Quote 


 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11945 posts

Posted 11 January 2017 - 12:23 AM #5

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?


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • markhedley
  • Advanced Member
  • Trial users
  • Join Date: 19-Nov 16
  • 129 posts

Posted 11 January 2017 - 02:51 AM #6

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?



 
  • poppedweb
  • Authorized Reseller
  • Members
  • Join Date: 02-Aug 16
  • 553 posts

Posted 11 January 2017 - 07:00 PM #7

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.


PoppedWeb | sales@poppedweb.com | https://poppedweb.com
TurnKey Website Design | Add-Ons | Performance Audits | Dedicated Server Management
24/7 Support | Response within an hour (during working hours).

 
  • mokeshop
  • Senior Member
  • Members
  • Join Date: 27-Jul 12
  • 1016 posts

Posted 11 January 2017 - 10:40 PM #8

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...pi-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...ject-1-cs-cart/



 
  • poppedweb
  • Authorized Reseller
  • Members
  • Join Date: 02-Aug 16
  • 553 posts

Posted 12 January 2017 - 06:53 AM #9

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...ject-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!


PoppedWeb | sales@poppedweb.com | https://poppedweb.com
TurnKey Website Design | Add-Ons | Performance Audits | Dedicated Server Management
24/7 Support | Response within an hour (during working hours).

 
  • poppedweb
  • Authorized Reseller
  • Members
  • Join Date: 02-Aug 16
  • 553 posts

Posted 12 January 2017 - 07:10 AM #10

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...ject-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_)


PoppedWeb | sales@poppedweb.com | https://poppedweb.com
TurnKey Website Design | Add-Ons | Performance Audits | Dedicated Server Management
24/7 Support | Response within an hour (during working hours).

 
  • poppedweb
  • Authorized Reseller
  • Members
  • Join Date: 02-Aug 16
  • 553 posts

Posted 12 January 2017 - 07:32 AM #11

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...ject-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!


PoppedWeb | sales@poppedweb.com | https://poppedweb.com
TurnKey Website Design | Add-Ons | Performance Audits | Dedicated Server Management
24/7 Support | Response within an hour (during working hours).

 
  • poppedweb
  • Authorized Reseller
  • Members
  • Join Date: 02-Aug 16
  • 553 posts

Posted 18 January 2017 - 05:06 PM #12

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!


PoppedWeb | sales@poppedweb.com | https://poppedweb.com
TurnKey Website Design | Add-Ons | Performance Audits | Dedicated Server Management
24/7 Support | Response within an hour (during working hours).