Zen Cart Logo
Forums / General Questions / Parse time: long

Parse time: long

Views: 2,344

Results 1 to 20 of 21
10 Oct 2011, 2:55 PM
#1
soniccc avatar

soniccc

Zen Follower

Join Date:
May 2010
Location:
Cyberspace
Posts:
387
Plugin Contributions:
0

Parse time: long

I would need a little help analyzing my parse and query times. I think the sites a little slow although I've compressed the images and removed the line breaks from my stylesheets.

These are the parse times I'm getting on my site: https://www.test.soundfactory.nu/index.php

Parse Time: 9.805 - Number of Queries: 187 - Query Time: 0.163528419266 - Home
Parse Time: 13.798 - Number of Queries: 192 - Query Time: 0.133284710846 - Product Info Page
Parse Time: 9.594 - Number of Queries: 294 - Query Time: 0.268267857056 - Product listing
Parse Time: 12.086 - Number of Queries: 405 - Query Time: 0.388754666229 -** Product Listing**
Parse Time: 6.693 - Number of Queries: 187 - Query Time: 0.444962588242 - Home

I've also uploaded a report from https://www.websiteoptimization.com.

Any thoughts on this is greatly appreciated!

10 Oct 2011, 6:14 PM
#3
soniccc avatar

soniccc

Zen Follower

Join Date:
May 2010
Location:
Cyberspace
Posts:
387
Plugin Contributions:
0

Re: Parse time: long

Thanks Dr. Byte. I will procure a remedy.

26 Oct 2011, 10:14 PM
#4
mshultise avatar

mshultise

Zen Follower

Join Date:
Feb 2005
Location:
Captain Cook, Hawaii
Posts:
172
Plugin Contributions:
0

Re: Parse time: long

I have a similar problem

Do I understand these numbers correctly?

He is doing a relatively few MySQL queries (in the hundreds) which seem to be retreiving quickly, however his webpages are taking forever to display ( 6 to 13 seconds)?

26 Oct 2011, 10:35 PM
#5
force avatar

force

New Zenner

Join Date:
Oct 2011
Posts:
21
Plugin Contributions:
0

Re: Parse time: long

I have the same exact issue right now...

Parse Time: 7.877 - Number of Queries: 331 - Query Time: 0.25484393214416

Home page:
Parse Time: 14.094 - Number of Queries: 152 - Query Time: 0.19727306770325

26 Oct 2011, 10:38 PM
#6
force avatar

force

New Zenner

Join Date:
Oct 2011
Posts:
21
Plugin Contributions:
0

Re: Parse time: long

Soniccc:

Thanks Dr. Byte. I will procure a remedy.

By any chance are you hosting with GoDaddy?

31 Oct 2011, 6:29 PM
#7
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Parse time: long

mshultise:

I have a similar problem

Do I understand these numbers correctly?

He is doing a relatively few MySQL queries (in the hundreds) which seem to be retreiving quickly, however his webpages are taking forever to display ( 6 to 13 seconds)?
Correct. The article I pointed to earlier explains it.

13 Feb 2012, 11:06 PM
#8
john6155 avatar

john6155

New Zenner

Join Date:
Feb 2012
Location:
Worldwide
Posts:
13
Plugin Contributions:
0

Re: Parse time: long

I am having the same situation with my website. I did a test and these were the results:

Home Page
Parse Time: 40.648 - Number of Queries: 4773 - Query Time: 3.22605777394

any suggestion?

**The website was running fine this morning and now it getting too much time to load, this is very frustrating :(

13 Feb 2012, 11:41 PM
#9
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Parse time: long

That means your webserver is overloaded with too many things running on it.

Maybe it's being targeted to send a ton of spam by malicious users, perhaps in another account on the same server.

The FIRST place you should make inquiries is your hosting company. Immediately.

14 Feb 2012, 12:10 AM
#10
john6155 avatar

john6155

New Zenner

Join Date:
Feb 2012
Location:
Worldwide
Posts:
13
Plugin Contributions:
0

Re: Parse time: long

DrByte:

That means your webserver is overloaded with too many things running on it.

Maybe it's being targeted to send a ton of spam by malicious users, perhaps in another account on the same server.

The FIRST place you should make inquiries is your hosting company. Immediately.

Thank you.

I contacted them now and I hope they can fix it . I will keep you informed on any progress :unsure:

**I am using fatcow hosting service. :unsure:

Do you think if i build my own server, this can be improve much better? :unsure:

14 Feb 2012, 8:05 AM
#11
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Parse time: long

John6155:

Do you think if i build my own server, this can be improve much better?
With all due respect, and no offense intended, but if you have to ask that question then you are not in a position to be building your own server.

14 Feb 2012, 2:15 PM
#12
john6155 avatar

john6155

New Zenner

Join Date:
Feb 2012
Location:
Worldwide
Posts:
13
Plugin Contributions:
0

Re: Parse time: long

DrByte:

John6155:

Do you think if i build my own server, this can be improve much better?
With all due respect, and no offense intended, but if you have to ask that question then you are not in a position to be building your own server.

I am really sorry and I apologize if I made a wrong question but I have not experience on this and that is the reason I came here. I never tought that I will receive that responsed. :(

--I fixed the issue-- :D

This is what I did

1- I went to admin/tools/store manager/ and I clean up the debug log files.
2- I logged into mysql database I clean up a huge Table used for SEO.
3- I logged into my root via FTP and delete the all files inside of the /cache folder.

After 1 hour, I could see the improvements. Now my result is
Parse Time: 5.494 - Number of Queries: 4719 - Query Time: 5.43673011412 :smartalec:

by the time an specialist contacted me, I had resolved this issue by myself or at least much much better by reading a little from everywhere. :cool:

14 Feb 2012, 2:20 PM
#13
john6155 avatar

john6155

New Zenner

Join Date:
Feb 2012
Location:
Worldwide
Posts:
13
Plugin Contributions:
0

Re: Parse time: long

I forgot

"Happy Valentine Day" :hug:

14 Feb 2012, 4:00 PM
#14
digitalshadow avatar

digitalshadow

Totally Zenned

Join Date:
Mar 2009
Posts:
616
Plugin Contributions:
0

Re: Parse time: long

John6155:

After 1 hour, I could see the improvements. Now my result is
Parse Time: 5.494 - Number of Queries: 4719 - Query Time: 5.43673011412 :smartalec:

I wouldn't say you have solved it.

Here is an example from my store

Parse Time: 0.952 - Number of Queries: 6265 - Query Time: 0.578116442001

To get a similar parse time, look at how many queries i've had to execute

Parse Time: 5.363 - Number of Queries: 37320 - Query Time: 1.5727082292

Your server is still slow.

14 Feb 2012, 7:01 PM
#15
john6155 avatar

john6155

New Zenner

Join Date:
Feb 2012
Location:
Worldwide
Posts:
13
Plugin Contributions:
0

Re: Parse time: long

DigitalShadow:

I wouldn't say you have solved it.

Here is an example from my store

Parse Time: 0.952 - Number of Queries: 6265 - Query Time: 0.578116442001

To get a similar parse time, look at how many queries i've had to execute

Parse Time: 5.363 - Number of Queries: 37320 - Query Time: 1.5727082292

Your server is still slow.

That is true. :(

but compare with what it was before :shocking:(Parse Time: 45.667 or 33.343 averague), I am on much better situation now. This is only happening with my store session becuase admin is at 1.234s to 2.234s parse time:huh:. I am looking foward to improve it and that is why I asked if it is better to make my own server (sorry for been a nobiew :no:). The specialist at the hosting service told me that it is a "good" parse time now (5 to 10s) :frusty:. What can I do? :wacko:

14 Feb 2012, 7:07 PM
#16
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Parse time: long

If your host thinks 5 to 10 seconds is a good time ... then it is time to find a new hosting provider ...

That does not always mean go build your own server ... most of the time it means finding a host who knows how to manager a server for ecommerce and MySQL properly to maintain speed and reliability ...

14 Feb 2012, 7:08 PM
#17
digitalshadow avatar

digitalshadow

Totally Zenned

Join Date:
Mar 2009
Posts:
616
Plugin Contributions:
0

Re: Parse time: long

If you intend to make money from your store, I would move to a faster server, keeping customers waiting isn't a good idea.

MODERATOR EDIT: There are Hosting recommendations on the tabs at the top of this page.*

14 Feb 2012, 9:22 PM
#18
john6155 avatar

john6155

New Zenner

Join Date:
Feb 2012
Location:
Worldwide
Posts:
13
Plugin Contributions:
0

Re: Parse time: long

Ajeh:

If your host things 5 to 10 seconds is a good time ... then it is time to find a new hosting provider ...

That does not always mean go build your own server ... most of the time it means finding a host who knows how to manager a server for ecommerce and MySQL properly to maintain speed and reliability ...

Definitely, I have to move forward and look for a really good one! :yes:. I am very impressive with your parse time results. it is really gorgeous :clap:. any hosting recommendation? :huh:

do you think that the inventory size matters because I have a large inventory? :unsure:

14 Feb 2012, 11:32 PM
#19
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Parse time: long

Without seeing your site, it is hard to judge if there are things that can contribute to any slow downs ...

15 Feb 2012, 10:31 AM
#20
digitalshadow avatar

digitalshadow

Totally Zenned

Join Date:
Mar 2009
Posts:
616
Plugin Contributions:
0

Re: Parse time: long

John6155:

do you think that the inventory size matters because I have a large inventory? :unsure:

I have 12000 products and around 8000 categories