[Dbix-class] Startup speed still too slow?

[Mark Lawrence]

On Tue Mar 18, 2008 at 06:05:14PM -0700, Byron Young wrote:
> Ben Hitz wrote:
> > Anyone had any luck getting this down below 2 secs?   I have 111
> > (Oracle) tables running on a not-particularly-fast old Sun V880.
> > Going to a base class wiith "load_components('Core') shaved
> > off 0.4 sec.
> >
> > I need to cut this time down to run AJAX queries ....
> 
> IMHO that you look into something like mod_perl or fastcgi for speeding up your ajax requests.  That way, the page your ajax request queries already has the modules loaded.  If the modules are already loaded, just doing the database queries plus whatever logic is in your page ought to be quick.
> 

SpeedyCGI is another reasonable alternative. IMHO it is slightly simpler
than mod_perl or fastcgi to setup, and can be used from the
command line if you are the kind of person who likes to automate CGI
tests that way.

For example, I often do the following which tells you why you are
getting an Internal Server Error without having to tail/grep the
webserver log file:

  HTTP_HOST=localhost REQUEST_URI=/some/path/ perl -Ilib bin/script.cgi

See http://daemoninc.com/SpeedyCGI/ or CPAN for details.

Cheers,
Mark.
-- 
Mark Lawrence