Print Page - Difference between hits and count

Title: Difference between hits and count
Post by: pankaj.puranik on June 21, 2013, 07:00:30 PM

Hi

What is the difference between hits and counts?

Agid(5103) Time(0.002) Hits(2) Count(201) Sql(2;AcctNum,SideKey;'0048787780','0048787780';WHERE ( ODTBL.AcctNum = ? OR ODTBL.SideKey = ? ) ) SqlR() OrderBy() TextSearch()

Thanks
Pankaj.

Title: Re: Difference between hits and count
Post by: subbu on June 09, 2014, 03:13:33 PM

Pankaj,

Were you able to find it out?

cheers
Subbu

Title: Re: Difference between hits and count
Post by: pankaj.puranik on February 03, 2016, 07:10:51 AM

Bumping it again!!

Title: Re: Difference between hits and count
Post by: Justin Derrick on February 04, 2016, 07:30:42 PM

I'd also like to know the answer to this question.

Title: Re: Difference between hits and count
Post by: ewirtz on February 09, 2016, 06:53:15 AM

Hi,

it's simple. count shows the maximum to read + 1. If you have configured to read a maximum of 200 results, Ondemand tries to read 201 rows to be able to decide whether more than 200 results do exist. This can be seen in count(nn) The count of the result set that is shown can be seen in hits(xx).

regards

Egon

Title: Re: Difference between hits and count
Post by: Alessandro Perucchi on February 09, 2016, 08:09:33 AM

Quote from: ewirtz on February 09, 2016, 06:53:15 AM
it's simple. count shows the maximum to read + 1. If you have configured to read a maximum of 200 results, Ondemand tries to read 201 rows to be able to decide whether more than 200 results do exist. This can be seen in count(nn) The count of the result set that is shown can be seen in hits(xx).

Thanks !!!!!!!!!!

Title: Re: Difference between hits and count
Post by: Justin Derrick on February 09, 2016, 02:33:14 PM

So, this effectively logs the configured 'Max Hits' value, plus 1?

OnDemand Users Group

Support Forums => CMOD for Multiplatforms => Topic started by: pankaj.puranik on June 21, 2013, 07:00:30 PM