Zen Cart Logo
Forums / General Questions / high query and parse times

high query and parse times

Locked

Views: 979

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
28 Jan 2010, 6:52 PM
#1
jimmyv avatar

jimmyv

Zen Follower

Join Date:
Feb 2008
Location:
Philadelphia
Posts:
292
Plugin Contributions:
2

high query and parse times

If both times are high does this automatically indicate poor server performance?

For some reason my site is much slower since I upgraded EP and that shouldn't matter I don't think to speed.

Parse Time: 17.482 - Number of Queries: 858 - Query Time: 7.24082623792

Any thoughts? I already am working with my host on this.

28 Jan 2010, 7:43 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: high query and parse times

Query time represents the time to perform the mysql calls
Parse time is rhe time the php is assembled at the server into a deliverable page

28 Jan 2010, 8:23 PM
#3
jimmyv avatar

jimmyv

Zen Follower

Join Date:
Feb 2008
Location:
Philadelphia
Posts:
292
Plugin Contributions:
2

Re: high query and parse times

Up until 5 - 10 days ago my site was wicked fast. So do these indicate a host problem completely?

They are directly related are they not? Meaning if your host is slow then everything will be slow.

But if your db is messed up somehow then same thing can happen can't it?

Or am I high? Little direction as I am not understanding the direction to go.

28 Jan 2010, 8:40 PM
#4
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: high query and parse times

But if your db is messed up somehow then same thing can happen can't it?
To check if it might be the DB
You should have a db backup prior to using/changing with EP
Take a fresh one
Apply previous one - check load times
Reapply the fresh one

28 Jan 2010, 8:46 PM
#5
jimmyv avatar

jimmyv

Zen Follower

Join Date:
Feb 2008
Location:
Philadelphia
Posts:
292
Plugin Contributions:
2

Re: high query and parse times

Yes I will try that but that is a hassle have to do it over the weekend. It just seems odd that EP would be related but I guess it could be. Only way to be sure...

Host is working on it too. It is probably them.

29 Jan 2010, 6:28 AM
#6
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: high query and parse times

Yes I will try that but that is a hassle have to do it over the weekend.
If you have the backup, making a current one and swapping twice is no more than 30 minutes

29 Jan 2010, 4:18 PM
#7
jimmyv avatar

jimmyv

Zen Follower

Join Date:
Feb 2008
Location:
Philadelphia
Posts:
292
Plugin Contributions:
2

Re: high query and parse times

Yes I understand but I can't really do it live so the weekend is better as you never know what hiccup will delay progress.

I appreciate your help. I did scan the sql again and that didn't help. I told my host MT that I had issues they told me a 16 second ping time was pretty good.

Pretty good. The frontpage page is 32k with 21k being image so I thought that was pretty well optimized better than most.

I am doing the free rackspace promo to see if i get the results I need or if it is a website issue. How do you ever really know unless you eliminate the pipeline as a possible reason.

I am shared with MT and another is dedicated and the dedicated still did not provide the results I'd expect. 32k should essentially be instantaneous IMO any delay would be on user side of issue I'd think.