Autocomplete Box Return Speed is Slow

Permanently deleted user

November 06, 2018 18:00

Hi everyone,

 

I was wondering is anyone could offer some advice as to how I can speed up an autocomplete box return.  Here is  little background, I have "inheritated" map service which contains land parcels and as far as I can tell it was published with the following details:

• 1. Un-indexed
• 2. From an SDE Feature Class
• 3. Published with a Join to a land owner information table in the ArcMap MXD
• 4. 17,000 records

The workflow runs an Autocomplete Box (within a Design Form) and queries an ArcMap joined field using ('{0}%') in the Where Clause.  The autocomplete box will eventually return a pick list but it takes several minutes.

 

Can anyone offer up some suggestions to speed up the return process?

 

Thanks,

 

Gary

 

 

0

• 

  Permanently deleted user

  November 06, 2018 18:22

  Hi Gary,

   

  You may be able to get away with a simple change like changing the "Min. Prefix Length".  If this value is too low, like 2 or 3, the query will return too many records and take a long time.  Try using a value of 4 or more to speed it up.

   

  Regards,

   

  Wayne Richard

   

  Latitude Geographics Group Ltd.

   

  Head Office: 300 – 1117 Wharf Street  Victoria, BC Canada V8W 1T7

   

  Tel: (250) 381-8130 | Fax: (250) 381-8132 | wrichard@latitudegeo.com 

   

  Developers of Geocortex web-based mapping software | www.geocortex.com

   

  An Esri Platinum Business Partner

   

   

  0
• 

  Scott Daniel

  November 06, 2018 18:56

  One thing I would change, if possible, is the Join.

   

  Create a view in SQL that "joins" the parcel feature class to the land owner table. Include all necessary fields especially the geometry field (SHAPE). Then, add that view as a layer in ArcMap. ArcMap will treat it like a feature class, and later refer to it as a "query". You'll see a huge improvement in performance. Any field that is queried on should be indexed.

  0
• 

  Permanently deleted user

  November 07, 2018 19:18

  Good idea's Scott's idea only will work on ArcServer 10.6 or later if you are using Active Directory integration. There was a bug on prior version that alllows you publish a map service fine using Active Directory Database Authentication but nothing shows. SQL Authentication works fine.

   

  Overall I had this problem with the USA Land Grid. I found rebuilding the spatial index plus adding indexing via ArcMap (vs SQL) to solve all the problems. There were not joins though so that might be a 2nd concern per Scott's idea after doing some indexing.

   

   

  0
• 

  Scott Daniel

  November 07, 2018 19:51

  I have been using views since much earlier than 10.6. As long as your SQL server supports geometry field types, it will work. I believe this was first supported in ArcGIS 10.3 and SQL Server 2008.

  0

Please sign in to leave a comment.