in reply to
Re: mod_perl vs php performance when accessing Oracle under load
in thread mod_perl vs php performance when accessing Oracle under load
We've been using Devel::NYTProf::Apache for analysing the main application, so I can have a go at that.
In the meantime I stripped out everything except the lines:
my $r = shift;
And it was still giving 1700ms per request - suggesting that its not the DB access at all...
The SELECT difference was a cut and paste error, the scripts on the server do both have the WHERE clause.