Zen Cart Logo
Forums / General Questions / "zencart has bloated sql calls to the mysql server"

"zencart has bloated sql calls to the mysql server"

Locked

Views: 1,733

Results 1 to 9 of 9
This thread is locked. New replies are disabled.
17 May 2006, 8:27 PM
#1
d9000 avatar

d9000

New Zenner

Join Date:
Jun 2005
Posts:
22
Plugin Contributions:
0

"zencart has bloated sql calls to the mysql server"

I was chatting with tech support at Chain Reaction Web today regarding the slowness of a ZenCart install, and they kept pushing me to convert to CRE Loaded. The tech support person gave me the following statements:

*Converting your cart to creloaded will help...zencart has bloated sql calls to the mysql server

*We have dropped support for zencart to all but existing customers because they haven't updated their code base

Can anyone speak to the validity of these statements? I'm disappointed that they are coming from a company whose front page states "Chain Reaction Web is #1 in osCommerce and Zen-Cart hosting".

17 May 2006, 8:42 PM
#2
kim avatar

kim

Obaa-san

Join Date:
Jun 2003
Posts:
26,591
Plugin Contributions:
0

Re: "zencart has bloated sql calls to the mysql server"

d9000:

*Converting your cart to creloaded will help...zencart has bloated sql calls to the mysql server

At this time, yes, there are a lot of sql calls to the DB. BUT, the reason there are so many is all of the features that are available on the front page. A search of the FAQs and forum should net you some very good speed optimization suggestions.

Also The next major release will have dropped the queries by about 80% with the change to MPTT for the categories menu and many other query optimizations.

d9000:

*We have dropped support for zencart to all but existing customers because they haven't updated their code base

:unsure: Some sour grapes there perhaps?

I might suggest you look at one of our other Certified Hosts.

17 May 2006, 9:51 PM
#3
d9000 avatar

d9000

New Zenner

Join Date:
Jun 2005
Posts:
22
Plugin Contributions:
0

Re: "zencart has bloated sql calls to the mysql server"

Thanks - I will check out the certified hosts section, and I was already planning to look through the optimization techniques.

In fact, I was asking them how much optimization techniques would help, and I think they misconstrued my questions as asking them to optimize it for me. Hence, the "we have dropped support for zencart" response.

17 May 2006, 9:52 PM
#4
kim avatar

kim

Obaa-san

Join Date:
Jun 2003
Posts:
26,591
Plugin Contributions:
0

Re: "zencart has bloated sql calls to the mysql server"

:thumbsup:

18 May 2006, 6:14 PM
#5
tatsumaki avatar

tatsumaki

New Zenner

Join Date:
May 2006
Posts:
13
Plugin Contributions:
0

Re: "zencart has bloated sql calls to the mysql server"

Also The next major release will have dropped the queries by about 80% with the change to MPTT for the categories menu and many other query optimizations.

any idea when the next major release will be released?

Thanks.

18 May 2006, 6:16 PM
#6
merlinpa1969 avatar

merlinpa1969

Totally Zenned

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

Re: "zencart has bloated sql calls to the mysql server"

dang 1.3 just came out

give em a minute to let the blisters on their fingertips heal and the moniter eye heal

18 May 2006, 6:20 PM
#7
misty avatar

misty

Inactive

Join Date:
Apr 2004
Location:
UK
Posts:
5,752
Plugin Contributions:
1

Re: "zencart has bloated sql calls to the mysql server"

give em a minute to let the blisters on their fingertips heal and the moniter eye heal
:rotflmao::clap:

1 Jun 2006, 2:43 PM
#8
ts232 avatar

ts232

Zen Follower

Join Date:
May 2006
Posts:
167
Plugin Contributions:
0

Re: "zencart has bloated sql calls to the mysql server"

Kim:

Also The next major release will have dropped the queries by about 80% with the change to MPTT for the categories menu and many other query optimizations.

Oooh, I am really looking forward to this! I've followed all the optimization paths, but am having customers complain about slowness on my small site. I understand that much of this is due to general dreamhost slowness, but hopefully this fix will address the problem.

I really don't want to have to move my store, forum, wiki and picture gallery over to a new host. Don't have the time.

1 Jun 2006, 2:54 PM
#9
maxus avatar

maxus

Zen Follower

Join Date:
Feb 2005
Location:
Prague
Posts:
130
Plugin Contributions:
0

Re: "zencart has bloated sql calls to the mysql server"

Im change 3 hoster befor I finde smart hoster owner who won help me tune my shop!

Now when I plane to start new shop - I need to buy only recommendet hosting
It is no problem if i open international shop.. but if you open local shop it is problem.. better to have server installed in local barebone network than on external network... local traffic and international traffic have differen speed and different cost

We wait new reliz 8)