Zikula Community

• mumuri
  
  

  • Rank: Developer
  • Registered: May 17, 2004
  • Last visit: Apr 08, 2010
  • Posts: 386

  Posted: Feb 08, 2008 - 01:56 AM

  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

  • 
  •  
• markwest
  
  

  • Rank: Team Member
  • Registered: Mar 18, 2002
  • Last visit: Oct 21, 2009
  • Posts: 6606

  Posted: Feb 08, 2008 - 10:27 AM

  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
  
  --
  Visit My homepage and Zikula themes.

  • 
  •  
• mumuri
  
  

  • Rank: Developer
  • Registered: May 17, 2004
  • Last visit: Apr 08, 2010
  • Posts: 386

  Posted: Feb 09, 2008 - 08:24 AM

  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)
  

  • 
  •  
•  
•  

Users on-line

• michiel,
• rgasch

This list is based on users active over the last 60 minutes.