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

["Philip M. Gollucci" <suppressed>]

> 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 structure, not on the database configuration.  You always get
> more from the former than the latter.
Particularly, the algorithms in the code, and you can sometimes(lots of times)
CACHE the results of SQL queries overtop of the "query cache/result cache" on the DB itself
aka Serialized to disk, or per process / request.



--
------------------------------------------------------------------------
Philip M. Gollucci (suppressed) 323.219.4708
Consultant / http://p6m7g8.net/Resume/resume.shtml
Senior Software Engineer - TicketMaster - http://ticketmaster.com
1024D/A79997FA F357 0FDD 2301 6296 690F  6A47 D55A 7172 A799 97F

"In all that I've done wrong I know I must have done something right to
deserve a hug every morning and butterfly kisses at night."
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /
 / /|_/ / // /\ \/ /_/ / /__
/_/  /_/\_, /___/\___\_\___/
       <___/