Difference between hits and count

[pankaj.puranik]

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.

[subbu]

Pankaj,

Were you able to find it out?


cheers
Subbu

[pankaj.puranik]

Bumping it again!!

[Justin Derrick]

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

[ewirtz]

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

[Alessandro Perucchi]

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 !!!!!!!!!!

[Justin Derrick]

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