TatukGIS menu

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