If this is your first visit, check our documentation. To post, register or login.
Forums / Basic Configuration / Speed & Performance..

Speed & Performance..

Locked

Started by gemohler on 10 May 2006, 9:07 AM · Views: 3,514

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
10 May 2006, 9:07 AM
#1
gemohler avatar

gemohler

Zen Follower

Join Date:
Jul 2005
Location:
CA
Posts:
223
Plugin Contributions:
0

Speed & Performance..

Carryin this on from what is now the Archive...

http://www.speedtoys.biz

Bout 20,000 items in the catalog.

Things were "ok" at 15,000, but the latest update has busted things slightly.

The Catalog in the Admin tool no longer loads, stops at 30 seconds...

Here is my server info as well (at bottom of post)

Turning off category counts helped enough that the store worked at 15k items.

I think ive created about as many relevant indexes in Mysql that I can do to speed it up.

The server load is rarely high enough to sweat this quad-cpu system, and I never catch it deep in swap..usually some RAM left free on the box.

..now what?

[Edit]

This new forum has a limit where I cant enter the server info text..too large. Might wanna change that folks..so people can post the support data.

MY Server info is at:

http://www.speedtoys.biz/serverinfo.html

10 May 2006, 6:24 PM
#2
gemohler avatar

gemohler

Zen Follower

Join Date:
Jul 2005
Location:
CA
Posts:
223
Plugin Contributions:
0

Re: Speed & Performance..

(a very polite bump for the thread)

10 May 2006, 7:55 PM
#3
theoracle avatar

theoracle

Suspended

Join Date:
Aug 2004
Posts:
3,180
Plugin Contributions:
1

Re: Speed & Performance..

Why not post your server info URL from zc_install/techsupp.php file ?

Simply upload that file to your Zen Cart's root path and post the URL. This will much more facilitate support for you. ;)

10 May 2006, 11:15 PM
#4
gemohler avatar

gemohler

Zen Follower

Join Date:
Jul 2005
Location:
CA
Posts:
223
Plugin Contributions:
0

Re: Speed & Performance..

TheOracle:

Why not post your server info URL from zc_install/techsupp.php file ?

Simply upload that file to your Zen Cart's root path and post the URL. This will much more facilitate support for you. ;)

When I get one..I will do that. I removed the install dir..it seems. Was many months ago.

10 May 2006, 11:26 PM
#5
wilt avatar

wilt

Oji-san

Join Date:
Jun 2003
Location:
Newcastle UK
Posts:
1,950
Plugin Contributions:
3

Re: Speed & Performance..

this is going to sound like a bit of a cop out, but 1.3.1 release is hugely focused on optimising code to use as few sql queries as possible, however you are going to have to wait for that.

There was a post a couple of months ago, with some code tweaks that reduced the query count a bit. I'll try and find it and post the link

11 May 2006, 1:19 AM
#6
gemohler avatar

gemohler

Zen Follower

Join Date:
Jul 2005
Location:
CA
Posts:
223
Plugin Contributions:
0

Re: Speed & Performance..

Thanks. Preciate it.