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

From: Daniel Vandersluis <daniel[@]greatgulfhomes.com>
Date: Wed, 8 Mar 2006 14:53:30 -0500

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

Daniel Vandersluis, Programmer
Great Builder Solutions
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
> function first of all, and secondly don't appear to be right (for
> 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
> was maybe about 1-2 seconds. Also, the numbers seem to be roughly equal
> 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?
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
Received on Wed Mar 08 2006 - 20:53:31 GMT

This archive was generated by hypermail 2.2.0 : Mon Jun 25 2018 - 06:00:04 BST