Page 1 of 2

Server Load time = SLOW

Posted: Tue May 15, 2012 9:03 am
by Bosephos
Okay, so I'm no professional at this by any means...so I really need some help. Thanks in advance.

Issue: My website load times are crazy... usually in excess of 17 seconds... I've checked it with pingdom.com and it seems that it doesn't even load the site until about 12 seconds into it... My hosting company(arvixe) assures me it's nothing on their end and that other opencart sites on the same server as my site are very fast. I have a LOT of products in my site...but VERY few are enabled...where should I start with this? I have no idea where to look.

My website is www.xploitdieselperformance.com

and I'm using opencart 1.5.1.3

Any help is GREATLY appreciated!!!

Re: Server Load time = SLOW

Posted: Tue May 15, 2012 9:51 am
by Avvici
My hosting company(arvixe) assures me it's nothing on their end and that other opencart sites on the same server as my site are very fast.
That's laughable. If someone from a hosting company told you this, then they are wrong. On a shared hosting plan load times are "always" up in the air especially with Arvixe. You are after all sharing bandwidth with many other people at the same time. I tried your site in all browsers on 10MB download and got about 8 seconds wait time which is something of concern. Ask them to move you to a different server. There isn't much going on with your website. Or, just go with In Motion Hosting. Their shared hosting is the best in my opinion. Them or host gator are both pretty fast for shared.

If you can afford it get on a VPS.....Virtual Private Server.

Re: Server Load time = SLOW

Posted: Tue May 15, 2012 9:52 am
by Avvici
I would suggest Tcalp or Q's modules but you have a problem that's pretty severe that needs dealing with before you spend money on caching modules.

Re: Server Load time = SLOW

Posted: Tue May 15, 2012 10:27 am
by JAY6390
My page cache mod could certainly improve the speed of this, however those load speeds are crazy slow, even for a shared host

Re: Server Load time = SLOW

Posted: Tue May 15, 2012 11:53 am
by rph
You have a very high time to first byte which means your issue is likely server side (you also have a very large banner image which will slow you down once the page does start rendering).

I see you have VQMod so start by disabling all of your mod scripts except for vqmod_opencart.xml and see if it impacts speed. If it does then re-enable them one at a time until you find the culprit then check with the author for support.

You also have a lot of categories so product count may be slowing your site down. If you can upgrade to 1.5.2 it allows you to disable this feature. Otherwise in:

catalog/controller/common/header.php

change:

Code: Select all

$product_total = $this->model_catalog_product->getTotalProducts($data); 
to:

Code: Select all

//$product_total = $this->model_catalog_product->getTotalProducts($data);   
and change:

Code: Select all

'name'  => $child['name'] . ' (' . $product_total . ')', 
to:

Code: Select all

'name'  => $child['name'], 

Re: Server Load time = SLOW

Posted: Tue May 15, 2012 12:49 pm
by Avvici
Huh? Many categories? Hardly. O0 Beyond that he has barely any products to COUNT when getting the (#) of products-to-category during run time. It could be many things, but not category count. I've seen larger websites load faster on better shared hosting plans and I would never recommend shared for anyone. Could be calls to javascript(s) that are non-existent or causing loops. Could be, "probably is" server side. As far as images go even if you have an image that is at 300 DPI loading in a cache for the first time it will be "seen" loading after the initial page load. Just saying lol. That's a major connectivity issue. I just waited 14 seconds that time.

Re: Server Load time = SLOW

Posted: Tue May 15, 2012 12:57 pm
by New Guy
I just left Arvixe. Arvixe is the worst web hosting company I have "ever" dealt with. I hope Open Cart find someone else to advertise with because my God they suck. I moved to Host Gator and my website sped up immediately. I am no dev like you guy's but I am just doing the Math. I had that I cannot afford a VPS but there are good shared hosting plans out there.

I had a similar issue where it just would not connect fast enough. My FTP is what gave it away. My FTP would take forever to connect as well and time out. They moved me to a different server on my request but no luck. I would recommend moving to Host Gator and purchasing Jay's page caching module. Or, in Motion Hosting.

Re: Server Load time = SLOW

Posted: Tue May 15, 2012 1:51 pm
by rph
avvici wrote:Huh? Many categories? Hardly. O0 Beyond that he has barely any products to COUNT when getting the (#) of products-to-category during run time. It could be many things, but not category count. I've seen larger websites load faster on better shared hosting plans and I would never recommend shared for anyone. Could be calls to javascript(s) that are non-existent or causing loops.
He has a 15 second time to first byte and you think it's javascript. ::)

There are ~60 categories and this is a known issue on 1.5.1.3. If there server sucks this is exactly what can happen.

Re: Server Load time = SLOW

Posted: Tue May 15, 2012 3:03 pm
by pressplay
I have a similar problem which is a major issue, would someone be able to help, see post http://forum.opencart.com/viewtopic.php?f=20&t=63543

Re: Server Load time = SLOW

Posted: Tue May 15, 2012 3:11 pm
by Avvici
rph wrote:
avvici wrote:Huh? Many categories? Hardly. O0 Beyond that he has barely any products to COUNT when getting the (#) of products-to-category during run time. It could be many things, but not category count. I've seen larger websites load faster on better shared hosting plans and I would never recommend shared for anyone. Could be calls to javascript(s) that are non-existent or causing loops.
He has a 15 second time to first byte and you think it's javascript. ::)

There are ~60 categories and this is a known issue on 1.5.1.3. If there server sucks this is exactly what can happen.
I was only making a point which is valid. Talking about "anything" but getting on a better server or perhaps even using the available page caching module is fruitless. That is all. Roll on.... roll on....

I still suggest that you tell them to place you on a different server, before you go with someone else.

Re: Server Load time = SLOW

Posted: Tue May 15, 2012 3:40 pm
by rph
avvici wrote:I was only making a point which is valid. Talking about "anything" but getting on a better server or perhaps even using the available page caching module is fruitless.
Javascript is never going to be an issue when the browser hasn't even received data.

Could it be the server? Yes, but it could also be other things. Why couldn't it be caused by a poorly functioning VQMod script, for instance? Changing servers is a major operation so it should be done last, not first.

Re: Server Load time = SLOW

Posted: Tue May 15, 2012 4:15 pm
by Helixir
:(
Installed lastest oc.
No any mods.
Create categories (20-50)
All ok. Nothing braking.

Import my price list to oc = 22k lines.

That all. Server respons main page 7-10 sec.

Mysql burn 99%

This is not hosting. I use VPS.

WHY? open any page - 10 sec mysql burned - and after page genereted.
Any fixes?

Re: Server Load time = SLOW

Posted: Tue May 15, 2012 4:25 pm
by Avvici
Helixir wrote::(
Installed lastest oc.
No any mods.
Create categories (20-50)
All ok. Nothing braking.

Import my price list to oc = 22k lines.

That all. Server respons main page 7-10 sec.

Mysql burn 99%

This is not hosting. I use VPS.

WHY? open any page - 10 sec mysql burned - and after page genereted.
Any fixes?
Hey there,
How about send us a link for starters, seeing that you just joined about an hour ago. And you cannot relate your issue to the original posters issue even if you are on VPS of Dedicated. You have different stats and different hosting. It's clear to me "without seeing your site yet" that the answer for your issue for starters would be to purchase these two modules right away:

http://www.opencart.com/index.php?route ... ort=rating

AND http://www.opencart.com/index.php?route ... name=Tcalp

Re: Server Load time = SLOW

Posted: Tue May 15, 2012 4:36 pm
by samolesong76
I have Open Cart 1.5.1.3 on a VPS with In Motion hosting. My category count is at 50 and my products are around 2190
I installed the above mentioned extension http://www.opencart.com/index.php?route ... ort=rating because I cannot afford to go any other route. The truth is that you do indeed get what you pay for that's why these guy's write these optimization scripts to help out those that can't afford a pricey dedicated rack of their own with gobs of processing and gobs of storage However, even if I did have gobs I still would want those scripts just to make sure.

On the other hand....shitty hosting is shitty hosting. If you are going for shared hosting I would recommend In Motion.

Re: Server Load time = SLOW

Posted: Tue May 15, 2012 6:22 pm
by JAY6390
There are lots of ways to optimise, some ways you just can't bundle into a script, but require a VPS/dedicated in order to do so. That said, I've seen sites with thousands of products and categories work just fine on crappy hosting, thanks to product count removal scripts and adding indexes to your tables among other small changes.

From what I've heard and seen, Arvixe really aren't a great company when it comes to shared hosting. The reason that OpenCart advertises them is because they provide the dedicated server that opencart runs on at no charge (or was the case at least, I'm not sure if that still is the case). It's a shame really that people go with them so much just because OpenCart advertises them. OC would likely be better getting a dedicated server of their own, with another for hosting, and have their own hosting platform dedicated to hosting OC sites in my opinion, rather than advertising a company who's record seems to be getting worse and worse

Hostgator are the shared hosting company I recommend these days. They're cheap, have great support and the servers are top notch as they deal with thousands of shared hosting accounts across a whole spectrum of servers. For those interested, you can also try the coupon GET25OFFPLAN which should give you 25% off your hosting plan

Re: Server Load time = SLOW

Posted: Tue May 15, 2012 7:15 pm
by Helixir
avvici wrote:
Hey there,
How about send us a link for starters, seeing that you just joined about an hour ago. And you cannot relate your issue to the original posters issue even if you are on VPS of Dedicated. You have different stats and different hosting. It's clear to me "without seeing your site yet" that the answer for your issue for starters would be to purchase these two modules right away:

http://www.opencart.com/index.php?route ... ort=rating

AND http://www.opencart.com/index.php?route ... name=Tcalp

Link: http://4power.pro

Re: Server Load time = SLOW

Posted: Tue May 15, 2012 11:52 pm
by Avvici
JAY6390 wrote:There are lots of ways to optimise, some ways you just can't bundle into a script, but require a VPS/dedicated in order to do so. That said, I've seen sites with thousands of products and categories work just fine on crappy hosting, thanks to product count removal scripts and adding indexes to your tables among other small changes.

From what I've heard and seen, Arvixe really aren't a great company when it comes to shared hosting. The reason that OpenCart advertises them is because they provide the dedicated server that opencart runs on at no charge (or was the case at least, I'm not sure if that still is the case). It's a shame really that people go with them so much just because OpenCart advertises them. OC would likely be better getting a dedicated server of their own, with another for hosting, and have their own hosting platform dedicated to hosting OC sites in my opinion, rather than advertising a company who's record seems to be getting worse and worse

Hostgator are the shared hosting company I recommend these days. They're cheap, have great support and the servers are top notch as they deal with thousands of shared hosting accounts across a whole spectrum of servers. For those interested, you can also try the coupon GET25OFFPLAN which should give you 25% off your hosting plan
I would venture to say that the reason why people go with them is because of the way they advertise. "Open Cart Hosting Made Easy". If I had no clue about anything and it was my first time going at ecommerce I would probably consider them too just because their name is tied to Open Carts.

Re: Server Load time = SLOW

Posted: Tue May 15, 2012 11:56 pm
by JAY6390
Agreed, it's a shame really. Too many sheeple I guess :)

Re: Server Load time = SLOW

Posted: Wed May 16, 2012 2:09 am
by Helixir
I try to find where this shit.
I comment query for categories in file:
/catalog/model/catalog/category.php

Code comment:

Code: Select all

public function getCategories($parent_id = 0) {
      //$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "category c LEFT JOIN " . DB_PREFIX . "category_description cd ON (c.category_id = cd.category_id) LEFT JOIN " . DB_PREFIX . "category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '" . (int)$parent_id . "' AND cd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND c2s.store_id = '" . (int)$this->config->get('config_store_id') . "'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)");
Then - i have normal load speed magazine. (with buglogs but speedy) With all products.
So. Maybe bug in code query db categories?
ohh

Re: Server Load time = SLOW

Posted: Wed May 16, 2012 3:58 am
by Avvici
Like rph suggested. I would start by disabling the product count. Most don't use the product count that shows up next to the categories anyway. You have boocus of products. Re-enable the script you just disabled and disable the wont suggested below.
catalog/controller/common/header.php

change:

Code: Select all
$product_total = $this->model_catalog_product->getTotalProducts($data);


to:

Code: Select all
//$product_total = $this->model_catalog_product->getTotalProducts($data);


and change:

Code: Select all
'name' => $child['name'] . ' (' . $product_total . ')',


to:

Code: Select all
'name' => $child['name'],