Re: DB troubleshooting with PDO
| From: | Richard Thomas | Date: | Sat, 18 Mar 2006 13:47:04 +0000 |
| Subject: | Re: DB troubleshooting with PDO | ||
| References: | 1 2 3 | Groups: | php.pecl.dev |
| Request: | Send a blank email to pecl-dev+get-3621@lists.php.net to get a copy of this message | ||
Yes, I was aware of that.
Basically what I was doing prior to PDO, I had a database class that if in debug mode recorded each sql query and how long it took.
I would output this data prior to xdebug data which made it real easy to track down slowdowns and redundant querys.
So while yes I can check the logs this provided a cleaner instant access to all the development info I needed in one location.
Richard Thomas - CEO
Cyberlot Technologies Group Inc.
507.398.4124 - Voice
David Tulloh wrote:
Mysql has a query log where it writes all the sql statements recieved, you will probably have to enable it. I suspect that this would be easier than adding hooks in PHP. David Richard Thomas wrote:Is it possible to somehow pull the final string submitted to mysql when you do a prepare/execute? What I would like to do is log all the querys in debug mode for troubleshooting and be able to review them afterwards.