Autocomplete Speed

Permanently deleted user

22. März 2017 20:24

I have a workflow that utilizes two autocomplete boxes that allows a user to search for a street number and name from a Parcel layer and then zooms to the point. The autocomplete boxes consistently take between 5 to 10 seconds for each to load the address. Is there anything that can be done to speed up the process?

 

https://drive.google.com/file/d/0B9MJ7nq1HIUCSzU2LXJhaVZsdG8/view?usp=sharing

0

• 

  Permanently deleted user

  23. März 2017 00:05

  Have you indexed the fields in the database?

  0
• 

  Kevin Penner

  24. März 2017 18:52

  What is the autocomplete where clause you are using? '%{0}%' queries can be much less performant to a trailing wildcard '{0}%'

  0
• 

  Permanently deleted user

  29. März 2017 21:11

  Another thing you can try is to increase the number of characters that are entered before the dropdown tried to populate.  we've done this for address searches and it helps quite a bit - instead of trying to return values after the 1st 3 digits, set it for 5 or 6 and it will be pulling from a smaller subset.

  0
• 

  Permanently deleted user

  30. März 2017 21:17

  Are you searching a File GDB or SDE?  While FGDB is faster for most layers, SDE is likely faster if doing any kind of db search...

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.