[RESOLVED] count PEAR DB queries executed

[Kudose]

Is there an easy way to get the total number of executed queries on a DB_common object reference?

i.e.

[at the bottom of the page]
Queries Executed: 10

[WesRatcliff]

Look at numRows() or using count() on the resulting array.

http://pear.php.net/manual/en/package.database.db.db-result.numrows.php

Wes Ratcliff

[Kudose]

Thanks, but that isn't really what I was looking for.

I could just as easily increment a static counter after each query. I am curious to know if, maybe somewhere hidden, a total number of queries performed on a single object is counted or can be easily counted.

i.e.

$db->query();
...more code...
$db->fetchOne();
...
$db->numRows();
...
echo 'Number of queries: '.$db->getTotalQueriesPerformedInMyLife();

[bradgrafelman]

Kudose wrote:

I could just as easily increment a static counter after each query.

Looks like that's about the only thing you can do.

For an example, see this page.

[WesRatcliff]

bradgrafelman wrote:

Looks like that's about the only thing you can do.

For an example, see this page.

I like that idea - building on that link from bradgrafelman, I would extend the mysql.php class's simpleQuery() method instead of directly modifying it in the PEAR source.

This is a much cleaner approach that won't be trampled on during PEAR upgrades.

Wes

[Kudose]

Sweet link.

Thanks again, as always, brad.