Forums / General Questions / Slow parse on 1and1 hosting - 15+ seconds to load home page!

Slow parse on 1and1 hosting - 15+ seconds to load home page!

Locked

Views: 4,466

Results 1 to 8 of 8
This thread is locked. New replies are disabled.
19 Jul 2007, 12:52 AM
#1
itsluy avatar

itsluy

New Zenner

Join Date:
Jul 2007
Posts:
1
Plugin Contributions:
0

Slow parse on 1and1 hosting - 15+ seconds to load home page!

Zen Cart has been running really slowly on 1and1 servers lately and I've heard that it could be the SQL server that we're on.
If i create a new DB it does place me on a different server (which is hopefully hosting less DB's than the current one)
I've done everything on the optimization suggestions and i'm still getting 15 second wait times to load the home page.
here's the parse results for a product:
Parse Time: 9.295 - Number of Queries: 203 - Query Time: 8.946520131073
Here's the parse results for the home page:
Parse Time: 11.251 - Number of Queries: 253 - Query Time: 10.914201716675

Does this make sense? 1AND1 has been no help whatsoever pointing the finger on Zen Cart.

So the question is: Should I migrate my store to a new mySQL DB (hence a new server) OR is there something else that could be causing this issue.

Thanks!!!

19 Jul 2007, 2:00 AM
#2
ajeh avatar

ajeh

Oba-san

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

Re: Slow parse on 1and1 hosting - 15+ seconds to load home page!

Changing databases is not the issue ...

Your server appears to be running slow ...

Contact your hosting site and ask that you be moved to a better optimized server that is not so overloaded as your site is a ... er ... umm ... dog ... :eek:

Have you an URL that we can peek at to see if there is anything else obvious that might be causing this? :smile:

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

20 Jul 2007, 2:14 AM
#3
oltox avatar

oltox

New Zenner

Join Date:
Jul 2007
Posts:
3
Plugin Contributions:
0

Re: Slow parse on 1and1 hosting - 15+ seconds to load home page!

I'm also running ZenCart on 1and1 and experiencing the same issue (slow parse time 15-20 seconds). As usual, 1and1 are saying that "everything is ok at their side...." The problem started about 2 weeks ago or so...

20 Jul 2007, 2:25 AM
#4
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,684
Plugin Contributions:
0

Re: Slow parse on 1and1 hosting - 15+ seconds to load home page!

PLEASE read all of the other posts about 1and1 - this is a problem that has been ongoing forever.

Please do not PM for support issues: a private solution doesn't benefit the community.

Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

20 Jul 2007, 2:32 AM
#5
jund avatar

jund

Zen Follower

Join Date:
Sep 2006
Location:
Ruckersville, VA, USA
Posts:
276
Plugin Contributions:
0

Re: Slow parse on 1and1 hosting - 15+ seconds to load home page!

Ajeh:

your site is a ... er ... umm ... dog ... :eek:

Easy now..........:smile:
jund

20 Jul 2007, 2:35 AM
#6
oltox avatar

oltox

New Zenner

Join Date:
Jul 2007
Posts:
3
Plugin Contributions:
0

Re: Slow parse on 1and1 hosting - 15+ seconds to load home page!

I just noticed that database Query Time is an issue, so I suspect they have problems with their mySQL servers...

Parse Time: 20.688 - Number of Queries: 458 - Query Time: 21.029207981094

20 Jul 2007, 4:18 AM
#7
oltox avatar

oltox

New Zenner

Join Date:
Jul 2007
Posts:
3
Plugin Contributions:
0

Re: Slow parse on 1and1 hosting - 15+ seconds to load home page!

itsluy,

I found a solution, at least for now...
Just backup your mySQL database and create a new database in 1and1 control panel. It will be created on a different server. Then upload your backup to the newly created database and change database settings in configure.php file.
My new timing is:
Parse Time: 0.485 - Number of Queries: 458 - Query Time: 0.34646584793091
Which is 40 times faster than it was on older mySQL server.

20 Jul 2007, 4:20 AM
#8
merlinpa1969 avatar

merlinpa1969

Totally Zenned

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

Re: Slow parse on 1and1 hosting - 15+ seconds to load home page!

keep an eye on it,

that box will soon fill up too

Zen cart PCI compliant Hosting