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
