Re: Performance question.

Quoting Ryan Hertz (rhertz@xxxxxxxxx):
> At 02:17 PM 6/14/01 , Gawain Reifsnyder wrote:
> >At 1:14 PM -0700 on 6/14/01, Caleb Crome wrote:
> >
> >>Hi,
> >>         I have a dual PIII, 600 MHZ server with 768 Meg of RAM.  I have the
> >>construct catalog set up, using interchange 4.6.5, mysql 3.23.36, perl
> >>5.6.0.  Linux Mandrake 8.0, mysql back end.
> >>
> >>When I run
> >>
> >>/usr/sbin/ab -c 3 -n 100
> >>'http://<my_site>/cgi-bin/construct/scan/fi=products/st=db/co=yes/sf=categor
> >>y/se=Hammers/va=link_image%3d/va=link_banner%3dHand%20Planes.html'
> 
> Dual PII 400 with 512M RAM, on live site, not the same URL, I tested:
> 
> ab -c 3 -n 100 
> http://yamamoto.baits.com/cgi-bin/order/scan/fi=products/st=db/co=yes/sf=cat 
> egory/se=hard
> 
> 5.86 requests per second.
> 
> Not using mysql, gdbm with careful indexes, about 250 records.

That is more like what I normally see.

This stuff is so very dependent on many things -- database indexing,
etc.

Probably the biggest win on a standard construct demo is

        [timed-build file=catlist minutes=20]
        ....
        [/timed-build]

around the left-side category stuff. Removes many queries.

-- 
Red Hat, Inc., 3005 Nichols Rd., Hamilton, OH  45013
phone +1.513.523.7621      <mheins@xxxxxxxxxx>

"Even if you're on the right track, you'll get run over if you just
sit there." -- Will Rogers