[xdebug-general] Re: New to XDebug -- a couple questions

Well, the company is moving over from coldfusion to PHP, and want to have
something similar to the CF debugging output (which displays a table of each
file that executed and how long it took to execute) -- that's what I'm
trying to figure out how to do (as it stands now, they have written their
own include/require[_once] functions to do timing, but I'd rather not do
that if at all possible.

In terms of SQL, maybe how long a SQL query takes to execute? CF spits out
something like "query_name (Datasource=postgresql, Time=453ms, Records=2) in
/path/to/file @ 14:46:41.041" and then spits out the actual SQL query (ie.
if you dynamically generated one, it would spit out what SQL was sent to the
DB. Obviously query_name is meaningless in PHP, but the other stuff can be
useful.

--
Daniel Vandersluis, Programmer
Great Builder Solutions
daniel[@]greatbuildersolutions.com
Telephone: (416) 441-1262 x2811
Fax: (416) 441-9085
-----Original Message-----
From: Derick Rethans [mailto:derick[@]xdebug.org]
Sent: Wednesday, March 08, 2006 2:44 PM
To: Daniel Vandersluis
Cc: xdebug-general[@]lists.xdebug.org
Subject: Re: [xdebug-general] New to XDebug -- a couple questions
On Wed, 8 Mar 2006, Daniel Vandersluis wrote:
> 1. How do I get the actual execution times, per file? I have xdebug2
> installed, and tried using file(xdebug_get_tracefile_name()); to get the
> information from the file, but the numbers it is reporting are obviously
by
> function first of all, and secondly don't appear to be right (for
instance,
> it reported that a function being called 1000 times in a loop (I was
> testing) took about 20-30 seconds to execute, when the visible time it
took
> was maybe about 1-2 seconds. Also, the numbers seem to be roughly equal
per
> function, no matter what the function is doing, which seems odd to me.
That indeed seems very odd - I've never encountered that myself. The
function xdebug_time_index()
(http://xdebug.org/docs-functions.php#xdebug_time_index) returns the
number of seconds since the start of the script.
> 2. Is there a way to profile SQL calls?
Not yet.. I am not sure how to handle this yet. Would you have a good
suggestion on how to do this?
Derick
--
Xdebug | http://xdebug.org | xdebug-general@lists.xdebug.org
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.2.0/276 - Release Date: 3/7/2006