Re: adding a comment after each SQL query

2008-05-30 Thread Primeminister
That is just great! Of course you have to overwrite. Didn't think of that. Thanx GriGri On May 30, 2:17 pm, grigri <[EMAIL PROTECTED]> wrote: > Remeber that debug_backtrace() is a very expensive function to call! > It might have a significant slowdown on your app's performance, even > if it is ju

Re: adding a comment after each SQL query

2008-05-30 Thread grigri
Remeber that debug_backtrace() is a very expensive function to call! It might have a significant slowdown on your app's performance, even if it is just in debug mode. Anyways, you just need to implement a custom datasource and override the logQuery() method. [assuming you're using MySQL - if you

Re: adding a comment after each SQL query

2008-05-30 Thread Primeminister
Hi Abhimanyu, The thing is that I want to know it on the live environment. The quantity of content in the database is slightly different then on my development environment. Anyway. Can you advise in a good debugger that has this tool? On May 29, 7:13 pm, Abhimanyu Grover <[EMAIL PROTECTED]> wr

Re: adding a comment after each SQL query

2008-05-29 Thread Abhimanyu Grover
I figured out best way is to use a debugger to do this debugging... I'll be monitoring this thread if someone has suggestions about this. On May 29, 8:02 pm, Primeminister <[EMAIL PROTECTED]> wrote: > Hi, > > I want to add a comment after each query that is build by cakePHP. > So when I do $this

adding a comment after each SQL query

2008-05-29 Thread Primeminister
Hi, I want to add a comment after each query that is build by cakePHP. So when I do $this->findAll($conditions) I want it to automagicly be added with a comment that will show up in my log. Example: SELECT * FROM posts AS Post WHERE id=12; /* getPost - posts_controller.php */ The comment is then