Re: mod_perl reqs/s @ concurrency-- for actual db based applications

2006-09-09 Thread Patrick Mulvany
On Wed, Sep 06, 2006 at 04:33:27PM -0500, Frank Wiles wrote: > On Wed, 06 Sep 2006 14:02:56 -0400 > Perrin Harkins <[EMAIL PROTECTED]> wrote: > > > You can usually increase your performance greatly just by tuning your > > existing SQL and database. Run Apache::DProf or the DBI profiler, > > find

Re: mod_perl reqs/s @ concurrency-- for actual db based applications

2006-09-06 Thread Frank Wiles
On Wed, 06 Sep 2006 14:02:56 -0400 Perrin Harkins <[EMAIL PROTECTED]> wrote: > You can usually increase your performance greatly just by tuning your > existing SQL and database. Run Apache::DProf or the DBI profiler, > find out where the time is being spent, and work on it. There are > many reso

Re: mod_perl reqs/s @ concurrency-- for actual db based applications

2006-09-06 Thread Jonathan Vanasco
On Sep 6, 2006, at 2:02 PM, Perrin Harkins wrote: That probably means you are limited by the database, like everyone else. right. i'm just wondering what the avg numbers for moderate logic apps are. I like httperf for benchmarks. its ok. it and ab haven't been updated in a while thou

Re: mod_perl reqs/s @ concurrency-- for actual db based applications

2006-09-06 Thread Philip M. Gollucci
You can usually increase your performance greatly just by tuning your existing SQL and database. Run Apache::DProf or the DBI profiler, find out where the time is being spent, and work on it. There are many resources for database performance tuning. Work on the actual queries and schema structu

Re: mod_perl reqs/s @ concurrency-- for actual db based applications

2006-09-06 Thread Perrin Harkins
On Wed, 2006-09-06 at 13:46 -0400, Jonathan Vanasco wrote: > with 2 children running, I'm handling ~70 r/s @ concurrency 10-1000 > 4-8 children seems to be my point for diminishing marginal utility- > in that range, I'm handling ~100 r/s @ concurrency 10-1000 ; and the > numbers don

mod_perl reqs/s @ concurrency-- for actual db based applications

2006-09-06 Thread Jonathan Vanasco
after talking with some people off list, I've got a question about performance under mod perl, for actual applications mp shows amazing performance marks with hello world, but few of us need to serve 1100 'hello worlds' personally, i'm seeing this: processor: p4 2.4 os: