Support Forum

i would like to know what the true mining of the sqlcount that we can display in the footer of the pages

in the options

Quote

1. $PNConfig['Debug']['debug'] = 1; //
2. $PNConfig['Debug']['pagerendertime'] = 0; // display page render time, 0 to disable
3. $PNConfig['Debug']['sql_adodb'] = 0; // adodb debug flag, generates lots of print output
4. $PNConfig['Debug']['sql_count'] = 1;

indeed if i count them in adodb-mysql.inc.php ( i added a global variable in the mysql_query function with an increment), the results are not the same.

is this normal ?
do you count only distinct queries ?

EDIT : the number is the same on "normal" page, but when i try to load the page of the pnForum 2.7 (for version PN .764), the number are differents.



edited by: mumuri, Feb 08, 2008 - 06:11 AM

-----
Top Flood - a discussions board based on pnForum

I don't have the code to hand to check this but if I recall this debug option only counts queries that go through the new object library. For all modules that use the old style direct access to the database connection the queries aren't counted here.

I assume that the queries display are less than those found via editing adodb directly?

-Mark

thanks for the answers,

yes it's less (40 queries displayed for a pnForum "viewtopic" page against 70 if i display the "true" number of queries)


-----
Top Flood - a discussions board based on pnForum