It's mostly trial and error here, and for that you'll want to use any of the web server benchmarking tools to help out ( such as 'ab' if you are using apache ). You might want to google up some of Rasmus's presentations on optimization to get a better idea on what to do. Here's a good one to get started on http://talks.php.net/show/tortech04/26. John On Dec 6, 2007 11:08 AM, Lewis Kapell <lkapell@xxxxxxxxxxxxx> wrote: > 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@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 > >> > >> > > > > > > -- > 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
