2. PHPRunner General questions
  3. [SOLVED]  Tracking sql commands
This topic is locked
[SOLVED]

 Tracking sql commands

 		3/1/2010 7:20:25 PM
PHPRunner General questions
A
 aramuni author

Hi,
There is a way to track the sql commands generated by PHPR code in order to tune the MySql database creating the correct indexes for each table?
Tks in advance!
Sergey Kornilov admin 3/1/2010

As a first step you can print all executed SQL statements on the Web page. For this purpose set $dDebug variable in include/dbcommon.php file to true (in version 5.2 this variable is located in include/appsettings.php file).
More info:

http://xlinesoft.com/phprunner/docs/debugging_tips.htm
A
 		aramuni author 3/2/2010

This is exactly what I was looking for.
Tks!