I am running a search for a particular query that I want to export the documents from.
When I run the query I base the total count on the TotalRowsIncludingDuplicates property as I want all items including any duplicates (this is the number actually displayed in the search centre when you run a search). When I look at the TotalRows property it tends to be quite a bit smaller.
I page the query using RowLimit and StartRow while TotalResults <= TotalRowsIncludingDuplicates. When I get to the TotalRows value the remaining queries up to TotalRowsIncludingDuplicates return 0 results.
I can't explain this discrepancy as I would expect to see the full duplicate result number. In some cases there is a delta of over 1k items.
Can anybody explain this please?