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
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]
