I am using the SQL index to build a list with Orders for a special type of supervisor.
Everything is fine unless a new order does not come in while the index is running. When this happens, the initial count and the actual count don;t match and the index fails.
I have noticed a nice feature on the product index that allows the index to complete even if the Product count dsoes not match.
Can something similar be added to SQL index?
Is there any other way to solve my problem?