NOTICE: Content Manager Community Consolidation
NOTICE: The Content Manager Community has been updated. Many disparate forums were consolidated into one and the community and forum have been updated to a newer, more user friendly "look and feel". Feel free to give us feedback on these changes in the Community Feeback area of our community. We're always looking for feedback to improve your experience..
Content Manager User Discussions

GPS Location Record Searches always time out?

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