Ask Your Question

Revision history [back]

The InKeyIndex functionality is only enabled when Limit=NONE.
I would suggest trying to do the pull of those three fields with it set to NONE.
You may need to increase your transaction timeout value to ensure it completes.
When I pulled all for Property:RE_1 it took around 3 minutes to download all 1,609,707 records.
Using query ((L_UpdateDate=2020-11-02T22:00:00Z-2020-11-09T21:00:00Z)|(L_Last_Photo_updt=2020-11-02T22:00:00Z-2020-11-09T21:00:00Z)) it took around 3 seconds to return 8,286 records.