[ic] Most Common Performance Issues

[Dan Browning]

At 06:32 PM 8/22/2002 -0400, you wrote:
>Our site is running IC on a DP 800Mhz Redhat box with 512MB of RAM with 
>SCSI disk.  This machine runs only IC.  The site is based off of the 
>foundation sample site and contains about 300 product using the standard 
>(non-RDBMS) database.  We have seen decreasing performance over the last 6 
>months the site has been up.  There is up to 4 IC processes running at a 
>time because of traffic.  Each page on the site takes from 2-10 secs to 
>generate.  This is across all platforms and browsers at LAN speed. If an 
>IC process has the machine to itself (only 1 user on the site), that 
>process will take 97% of the CPU.  While this is understandable, even when 
>there is 1 process, it still takes ~4 seconds to generate a page.  I don't 
>know how a machine as powerful can get floored by 4 concurrent users.
>
>Currently we run expireall each day.  This seems to help a little.
>
>What else could I do (configuration, cron, etc) to work on performance?
>
>Thanks,
>Michael

Try going to rpc mode, if you haven't already (see interchange.cfg), this 
is equivalent to Apache PreFork mode.

However, moving to SQL isn't very difficult (Variable MYSQL 1 and Variable 
SQLDSN ...) and it brings a lot of benefits, namely speed.

I'll see if I can add these tips and others to the Performance FAQ (which 
I'm sure you've seen):

http://www.icdevgroup.org/cgi-bin/ic/docfly.html?mv_arg=icfaq11.00

Good luck!

/~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\
| Dan Browning, Kavod Technologies      <dan.browning@kavod.com> |
| (360) 882-7872 x7, 6700 NE 162nd Ave, Suite 210, Vancouver, WA |
\~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~/
Advice to young men: Be ascetic, and if you can't be ascetic,
then at least be asceptic.