Re: Optimization/Benchmarking tools?

John, Thanks for the tip. In just a short time, this tool helped me to find the big bottlenecks in my scripts. However, as far as I can tell, the Xdebug profiler gives no information on the loading/parsing phase of PHP script execution. I would like to determine how much benefit I can get by taking steps to reduce PHP file sizes, for example (removing comments, breaking up large classes into several files, etc.) or by refactoring the code so that I can use exclusively require() instead of require_once(). Can anyone suggest a tool for measuring this? Thank you, Lewis Kapell Computer Operations Seton Home Study School John Mertic wrote:

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@setonhome.org> 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