prob with ApplyQuery for data range

Cisco_Developer_(ciscouser2_-_(deleted))

HiMy OTSTARTS query to get the objects based on thier modification time does not fetch results and at times it kills the search engine itself, Any ideas why this is happeningthe query is as below( [ region "OTLocation" ] "29132" ) AND (([ region "OTSubTypeName" ] "Discussion") OR ([ region "OTSubTypeName" ] "Topic") OR ([ region "OTSubTypeName" ] "Reply") ) AND (([ region "OTModifyDate" ] >= "20050620" ) AND ([ region "OTModifyDate" ] <= "20050622" ))

Tina_Wang

If you enable the search logs you'll probably see what's happening. From the looks of the query, you are probably exceeding the firewall. When you are searching (([ region "OTModifyDate" ] >= "20050620" ) AND [region ([ region "OTModifyDate" ] <= "20050622" )), you aren't really searching for all the documents modified between those two dates. You are looking for all numbers in the index that are greater than 20050620, then checking those results to see which ones are also in the OTModifyDate region. After that you are searching for all numbers in the index that are less than 20050620, then checking those results to see which ones are also in the OTModifyDate region. There will likely be a lot of numbers less than 20050620 in your index.