[freeside] Performance issues

[Ivan Kohler]

Using mod_perl will give a _drastic_ performance improvement, as
Perl code will be cached in compiled form (per Apache child).
<http://perl.apache.org/>.

For example, in my K6-200, it takes about 4 seconds for the New Customer
screen to come up.

You also want to use the Apache::DBI perl module, which provides
persistant database connections - especially if you are using PostgreSQL,
which has much higher connection overhead than MySQL.

There are some bits of code which could be optimized, still.  Most
potential optimizations involve caching data (from the database or
filesystem) and thus would probably end up requiring a server restart for
changes to configuration files or the Administration menu settings to take
effect. 

On Sat, Oct 02, 1999 at 02:55:26PM -0700, Kristian Hoffmann wrote:
> We run freeside on a PII Celeron 300.  It generally takes 5-10 seconds for
> any sort of query or a new customer screen to come up.  If you watch top
> when you do the query, you can see perl taking up 90-95% of the cpu time.
> It's a bit scary to watch, but I guess it's expected when it's running
> through as much perl script as it does.
> 
> -Kristian
> 
> On Sat, 2 Oct 1999, dk smith wrote:
> 
> > We are currently using freeside on a Pentium Pro with 200 MHz running
> > FreeBSD. We also tried it on a 4 processor SMP SPARC-Linux varietal. We see
> > a delay of approximately 17-19 seconds for the "New Customer" screen to
> > come up on both machines.
> > 
> > Do we need to throw more hardware computing power at this beast or do some
> > methods exist to tune the system to get better performance?
> > 
> > I would appreciate any shared experiences. Please post to list unless you'd
> > prefer me to summarize back to the list.
> > 
> > Thanks,
> > dk
> > -- 
> > dks at spies.com   |   Perception is nine tenths of the law.
> > 
> 

-- 
Ivan Kohler <ivan at sisd.com> - finger for PGP key - <moc.dsis at navi> Relhok Navi
Open-source billing and administration for ISPs - http://www.sisd.com/freeside
20 4,16 * * * saytime # please don't be surprised if you find me dreaming too