Website SLOOOOW

Hi my website is very slooow:cry: and i am trying to speed it up.
Anyone have any ideas?
I have enabled parse times which vary from 6 - 59seconds

Here is a link to it!

20 seconds to load a page for me. Id change your hosting.

The stupid thing is it was taking about 1 second and now all of a sudden it has Slowed right down is it because of something i have done or????

You tell me...Is there anything you have done? If not, then its your server.

Well i only had two products before and now i have liek 31 added in there but that is all - as far as i understand it it shouldn't slow it down!

I called the hosting company and they say i have some indexes the need redoing or something what do they mean??????

dgent:

20 seconds to load a page for me. Id change your hosting.

Also i have a Zen-Cart recommend host! http://www.zen-cart.com/index.php?main_page=infopages&pages_id=10

Lol, if they are Zencart recommended Id get them to tell you the exact problem.

wow that was slow! have you tried reverting back to the classic template to see if that is slow too?

ray-the-otter:

wow that was slow! have you tried reverting back to the classic template to see if that is slow too?

Yes that is slow as well - 20 secs+
My admin is slowing down now as well - it must be the host!!!:frusty:

dgent:

Lol, if they are Zencart recommended Id get them to tell you the exact problem.

I contacted my host they said> First make sure all your plugins/themes/dashboard is up to date, then look for any slow sql queries (located at /tmp/mysql_slow_queries/), and perform some optimization on your Databases

I located the slow queries - i have 21 in my last file but none of them are over 2 secs most are 1.0 - 1.6 is that really going to slow me down to a 20sec - 58sec load time???:unsure:

I gave up waiting for your site to load after about a minute and a half. It's acting like a resource problem. There's a site on the server, (maybe yours), that is using too much CPU or memory.

RescoCCC:

I gave up waiting for your site to load after about a minute and a half. It's acting like a resource problem. There's a site on the server, (maybe yours), that is using too much CPU or memory.

Ok they cam back with this now

it could be:-

1. A huge spike in Additional Traffic.
2. A Dynamic Site without caching.
3. Extremely Large or non-optimized graphics.
4. Extremely Large or non-optimized database.
5. Large amount of external calls.
6. Server issue.
   My answers are

1. No this as its not live yet!
2. Does Zen-cart cache or not??
3. Use IH3 so they are optimized
4. Optimized the database as per the hosted instructions
5. How do i tell??
6. They should be telling me that!

Can anyone tell me the answers to 2 and 5???

All your slow responses appear to be revealing that the MySQL database is running too slowly.
See: https://www.zen-cart.com/tutorials/index.php?article=105

Zen Cart does not cache, nor does it need to. It works perfectly fine for very large stores without needing any PHP-level page caching. If the server's MySQL database engine is poorly tuned and not well suited for dynamically-driven sites, then that particular server's clearly not suitable for running an ecommerce site. Your host should be able to put you onto a server that's better tuned and not home to thousands of other sites that are competing for resources. Find out how many other sites are on the same server, and ask to be put on one that's got a lot less, and won't get overloaded.

Zen Cart, out of the box, doesn't do any external calls in order to draw its regular pages. The only time it needs to do that is if you're using a shipping module that requires asking for a quote for the selected shopping cart contents, or for processing payment. By no means would either of those be considered a "large amount" of external calls. Except maybe if some remote bot is hammering your site for shipping-estimator quotes, which is highly unlikely.

Thanks Dr Byte - i have sent a link to this thread to the support desk and have asked for the same thing so.. Watch this space...

OK the hosting company came back with:

We do have a PRO PLAN that has only 300 users on it.
The Pro Plan includes all of the standard hosting features plus the following:

More CPU, memory and resources
SiteBackup Pro
Free Dedicated IP address
Free SSL Certificate
Free domain name
Free domain privacy
Free Postini Anti-Spam Accounts (10)

There are 80% less users on the Pro Plan servers and thus allow for more resource allocation which will effect processing power.

Its more expensive but is it going to solve the problem??:unsure:

Ask them why a Zencart certified host can't handle a Zencart store with only 30 products on it, and no traffic before you give them any extra money...

End of the day you said your site was fine, then it went really slow. How is that your problem? They should be moving you for free.

dgent:

Ask them why a Zencart certified host can't handle a Zencart store with only 30 products on it, and no traffic before you give them any extra money...

End of the day you said your site was fine, then it went really slow. How is that your problem? They should be moving you for free.

They are trying to say it is a problem with my index page but the default classic template makes no difference!:frusty:

Am working on trying to get a free trial!

You could quickly set up a demo store in a new folder, using the default demo populated products, and see if that runs slowly too.

dgent:

You could quickly set up a demo store in a new folder, using the default demo populated products, and see if that runs slowly too.

Thanks for your reply dgent!

I installed a clean version from cpanel so there is no demo but check it out it is still slow!

gazag:

Thanks for your reply dgent!

I installed a clean version from cpanel so there is no demo but check it out it is still slow!

Go tell them then - they can't argue with that!