2. PHPRunner General questions
  3. Record Count
This topic is locked

Record Count

 		10/21/2010 6:54:23 AM
PHPRunner General questions
F
 FreddieM author

I noticed that on every page a "count(*)" is done of all the records in the table. Is there anyway of stopping this from happening?
I assume this is done for the "Details Found" bit on the page but I don't need that.
Thanks
Sergey Kornilov admin 10/21/2010

You can turn off 'Display number of child records' option in Master-Details relationships.
F
 		FreddieM author 10/22/2010

Thanks.
That is not quite what I mean though. There are no relationships set up to any other tables, this is just a standard list page. If you turn the debug option on so it prints the SQL queries out onto the page you will see it always does a count(*) query on the table. I was wondering why it does this and also if there is any way to turn it off.
A
 		ann 10/22/2010

Freddie,
this option is used to calculate number of records returned from database, number of pages, etc.
Unfortunately you can't turn this option off directly in the wizard.

You can manually delete {details_block} on the List page on the Visual Editor tab.

Then you can delete the call of the GetRowCount() function in the generated \classes\listpage.php file.
Please also note that pagination won't work in this case.

Unfortunately we don't have a ready to go solution for this.