Content Manager (RM) Forum
cancel

GPS Location Record Searches always time out?

Highlighted
Sten28 Outstanding Contributor.
Outstanding Contributor.

GPS Location Record Searches always time out?

Tested in 9.1 Patch 3.

I cannot seem to be able to get any GPS Searches to work - they always result in a SQL timeout. Just wondering if anyone else has experienced this behaviour?

I am working with over 10 million records - if I adujst the query to look for a smaller subset (less than 20) I will still get timeouts. 

I've extracted the SQL for a simple "GPS Point" search and I can see why SQL would be having trouble, it is passing a large number of parameters (see below).


HP Garage GPS Search.png