Hi Guys,
I hope someone can point me in the right direction here. We have an existing site written in php and uses a mysql database. We are having to upgrade to a Postgre database because of a bookeeping application we are using and mysql does not support all the features needed.
The problem is, even with a better proccessor and more ram, the site seems to move slower. There seems to be a pause in front of executing any command. The entire navigation of the site is db driven but there are only certain areas where it gets intensive otherwise we are just serving up some html templates but they also take forever. If I time it, I click on the FAQ page of my site from the homepage on the mysql version it opens immidiately. If I do the same on the postgre site it pauses and then delivers the page. It takes about 4 seconds.
Anyway, perhaps this is a common thing for a newbie or something that we need to get more help with but opinions would be appreciated. Here is the new server inventory;
Linux Fedora Core 3
PHP 5.0.3 + PHP Zend Optimizer
Apache 2.0.53
MySQL 4.1
PostgreSQL 8.0
Perl 5.8.6
DBD-Pg latest
DBI latest
