Xdebug and WinCacheGrind are your friends here. Read more at http://xdebug.org/docs/profiler. John On Dec 5, 2007 11:01 AM, Lewis Kapell <lkapell@xxxxxxxxxxxxx> wrote: > Hello all, > > I have a couple of web sites which rely heavily on PHP and PostgreSQL. > Sometimes, pages which have a lot of dynamic content take several > seconds to load. > > In order to improve my sites' performance, I need to know where the > bottlenecks are. I need a tool or tools that would allow me to analyze > my sites' behavior to determine where my optimization efforts should be > focused: should it be on the PHP scripts, on the SQL queries or database > configuration, on aspects of the server configuration, etc. > > I am using PostgreSQL 8.2.5, PHP 5.2.5, and Microsoft Internet > Information Server (IIS) 6.0. > > I have the Postgres server set up to record any queries whose execution > takes longer than a certain interval. By inspecting the logs, I was > able to identify poorly performing queries; in most cases, creation of > appropriate table indexes resolved the problem. So, that is one aspect > of server optimization that I think I have already done pretty well. > Other than that, however, I don't really know where improvements need to > be made. > > Thanks to any who can advise. > > -- > > Thank you, > > Lewis Kapell > Computer Operations > Seton Home Study School > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- John Mertic jmertic@xxxxxxxxx http://jmertic.wordpress.com "Explaining a joke is like dissecting a frog: you understand it better, but the frog dies in the process." --Mark Twain
