Forums / Installing on a Linux/Unix Server / 1.3.01 install = painfully slow!

1.3.01 install = painfully slow!

Locked

Views: 2,177

Results 1 to 9 of 9
This thread is locked. New replies are disabled.
7 Jul 2006, 7:15 AM
#1
futurefreak avatar

futurefreak

New Zenner

Join Date:
Aug 2005
Posts:
13
Plugin Contributions:
0

1.3.01 install = painfully slow!

I have an existing shop at: https://www.futurefreak.co.uk/catalog version 1.2.6
and I'm in the process of seperating out the baby from the adult stuff - so I thought I'd make a brand new shop and use the latest version: 1.3.0.1

This is not live yet but can be seen at http://www.futurefreak.co.uk/baby

First time I visit the index page -

Parse Time: 95.114 - Number of Queries: 70 - Query Time: 87.83100935733

a refresh a min or so later results in:

Parse Time: 2.001 - Number of Queries: 69 - Query Time: 0.81024710966492

I have:
IP to Host conversion turned off.
and Category counts turned off.
and both sites are hosted on the same server and database, so it's not a hosting issue as the 1.2.6 version runs ok.

I have seen talk of adding indexes to the database to speed things up - but that was for version 1.2.5 - do those indexes still apply for 1.3.0.1 ?

Is there anything else I can do to speed up the initial hit? As 95 seconds is a disaster for a first time customer.

7 Jul 2006, 7:17 AM
#2
reesy avatar

reesy

Totally Zenned

Join Date:
Mar 2005
Posts:
535
Plugin Contributions:
3

Re: 1.3.01 install = painfully slow!

Those figures are primarily because of your host, id speak to them.
I have the same code running on my site and it runs in a lot less time.

7 Jul 2006, 7:23 AM
#3
futurefreak avatar

futurefreak

New Zenner

Join Date:
Aug 2005
Posts:
13
Plugin Contributions:
0

Re: 1.3.01 install = painfully slow!

Reesy:

Those figures are primarily because of your host, id speak to them.
I have the same code running on my site and it runs in a lot less time.

Please read the post properly and please don't just throw around the usual "it must be the hosting company", because as I said in my post "and both sites are hosted on the same server and database, so it's not a hosting issue as the 1.2.6 version runs ok."

7 Jul 2006, 7:26 AM
#4
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
4

Re: 1.3.01 install = painfully slow!

I got this on a first click
Parse Time: 2.563 - Number of Queries: 70 - Query Time: 1.4751065795746

and your bg header image is broke,

your image size is kinda high, the baby_ls_layered.jpg is 65 kb
the header bg is 325 kb

wont help much but it should help some

Zen cart PCI compliant Hosting

7 Jul 2006, 8:02 AM
#5
kuroi avatar

kuroi

Totally Zenned

Join Date:
Apr 2006
Location:
London, UK
Posts:
10,475
Plugin Contributions:
11

Re: 1.3.01 install = painfully slow!

FutureFreak:

Please read the post properly and please don't just throw around the usual "it must be the hosting company", because as I said in my post "and both sites are hosted on the same server and database, so it's not a hosting issue as the 1.2.6 version runs ok."Wow, great way to encourage people to help you.

Sorry, but I agree with Reesy. There is clearly a very wide variation in the time your server is taking to process requests. My first load returned Parse Time: 1.269 - Number of Queries: 70 - Query Time: 0.4227, which is less than half the time Merlin recorded and a fraction of the time you got for a first load. This suggests that it's not the code base that is causing the variation. So unless you're on a dedicated server, I'd be asking questions about what sort of server loading might be causing this level of variation.

Kuroi Web Design and Development | Twitter

(Questions answered in the forum only - so that any forum member can benefit - not by personal message)

7 Jul 2006, 10:18 AM
#6
pauls avatar

pauls

Zen Follower

Join Date:
Feb 2006
Location:
UK
Posts:
300
Plugin Contributions:
0

Re: 1.3.01 install = painfully slow!

Yep, I concur with reesy and kuroi, very much a hosting issue, I am in the UK

Parse Time: 6.634 - Number of Queries: 67 - Query Time: 4.2875491931305

Parse Time: 43.023 - Number of Queries: 68 - Query Time: 37.414541466248

Parse Time: 4.480 - Number of Queries: 68 - Query Time: 2.3656127945404

Parse Time: 2.338 - Number of Queries: 67 - Query Time: 1.0994702025299

Parse Time: 3.106 - Number of Queries: 67 - Query Time: 1.3852447905884

You see the one thing that is constant, is your code and your images, therefore the likelyhood is your host.

You can and should set Gzip compression to 1 if you have not already done so, there is something that can be done with the database too that helps speed things up, but I do not believe these settings alone will help. As was suggested have a chat with your host.

7 Jul 2006, 10:39 AM
#7
reesy avatar

reesy

Totally Zenned

Join Date:
Mar 2005
Posts:
535
Plugin Contributions:
3

Re: 1.3.01 install = painfully slow!

FutureFreak:

Please read the post properly and please don't just throw around the usual "it must be the hosting company", because as I said in my post "and both sites are hosted on the same server and database, so it's not a hosting issue as the 1.2.6 version runs ok."

Yes I read your first post and my reply is still valid.
A simple google search shows you did have an osc store and had problems with the osc sid being appended because of your configure files were wrong.
Good luck with zen cart and following simple instructions.

7 Jul 2006, 3:18 PM
#8
parafanaylya avatar

parafanaylya

Totally Zenned

Join Date:
Jul 2005
Location:
Hoedspruit
Posts:
470
Plugin Contributions:
1

Re: 1.3.01 install = painfully slow!

Parse Time: 15.632 - Number of Queries: 70 - Query Time: 13.274990221466

1st time and

Parse Time: 4.566 - Number of Queries: 69 - Query Time: 2.452109969696

2nd

and 3rd:

Parse Time: 1.939 - Number of Queries: 67 - Query Time: 0.65089631196594

from South African broadband switching between IE and Firefox doing a cache clear refresh.

your image size is kinda high, the baby_ls_layered.jpg is 65 kb

Bomb the big image

7 Jul 2006, 3:28 PM
#9
parafanaylya avatar

parafanaylya

Totally Zenned

Join Date:
Jul 2005
Location:
Hoedspruit
Posts:
470
Plugin Contributions:
1

Re: 1.3.01 install = painfully slow!

but then navigating to a new page, I get this:

Parse Time: 19.940 - Number of Queries: 244 - Query Time: 17.104314694092

Time to move on - but I can't help technically, and I had similar issues (loading specials in admin up to about 5 minutes/product) - and then ended up moving from one server to the next. It went slower, until I moved to a ZC specialist host. Although there are sporadic, and frustrating issues my site now loads 300% faster than previous best, and the new server sounds like it's powered by a Ferrari or something.

But like you say, your exising/catalog site is acceptable!