[ic] Interchange using lots of cpu...

[interchange-users@icdevgroup.org (Mike Heins)]

Quoting gordon@nextrieve.com (gordon@nextrieve.com):
> > 
> > I've recently used interchange to whip up a demo accessing mysql data, but   
> > have noticed that it seems to consume lots of cpu for a long time filling out
> > templates.  Admittedly we've brute-forced the demo; it's using
> > a couple of nested [query] type statements with some [if]s inside to generate
> > the output list.  But it can take 90 seconds of spinning to generate
> > a few hundred lines of results.
> > 
> > We're using interchange 4.8.6 on a redhat 7.3 system.  It's a 1ghz
> > processor with 512mb of ram.  Running top shows that's it's really interchange
> > sitting there using the cpu.  It's not idle, using lots of memory or using
> > the disk.  I've looked at the 'list optimization' page on the icdev site
> > which was quite interesting, but didn't really solve this problem.  Mysql
> > can find the raw data in fractions of a second.
> > 
> > Is there some tuning parameter that I've missed?  Any perl-related installation
> > issues?  I can't believe it's this slow normally but can't find anything
> > obvious.
> > 
> 
> I've investigated further and, from what I can see, there's some rather
> nasty slow-downs somewhere when an sql query using [query] returns
> lots of results.

    http://www.icdevgroup.org/i/dev/docfly.html?mv_arg=icfaq14.02

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.513.523.7621      <mike@perusion.com>

Research is what I'm doing when I don't know what I'm doing.
-- Wernher Von Braun