Knowledge Base



KB10481 - Increase speed of attribute query to localize a shape on the map.

  • Consider converting the map layer from SHP or other file format into an SQL database layer and use the database tools to assign an index to the file being searched on.
  • Remember that queries using the LIKE statement are always slow if the first few letters are not provided. For example, never use the search construction: "NAME LIKE '%gton'". Instead use: "NAME LIKE 'Wash%'"
Created: January 30, 2004, Modified: August 28, 2015
follow us on Facebook  follow us on Twitter  follow us on Google +  follow us on LinkedIn  Embarcadero