[andynic]

Hi,

Any ideas what might be going on here?

Some months ago I developed a database management application that had a very fast response time -- click a button and immediately the next page displayed (with or without a database access).

For several months the application has been dormant. I am now using it again, and between button clicks I need to wait from 5 to 15 seconds.

The applcation was developed under and is still using:
Mac OS 10.6.8
Apache 2.2
MySql 5.1.39
Perl 5.10.0
Perl CGI
Perl DBI
DB connect method:
$dbHandle = DBI->connect("DBI:mysql:database=$GCdbSchemaName", $GCdbUn, $GCdbPw)

The only "significant" change to the system in the time the above application was dormant, is that I activated PHP and have developed a second application using all of the above, but instead of Perl and Perl CGI, I am using PHP. Can the configuration of Apache and the the PHP init file be having an impact on the performance of the first application?
$ php -v
PHP 5.3.4 (cli) (built: Dec 15 2010 12:15:07)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
with Xdebug v2.1.1, Copyright (c) 2002-2011, by Derick Rethans


Thanks for your help.
Andynic