very slow query

6/16/2014 11:38:34 PM
Total Posts 5

very slow query

Hi,

The like search expression is very slow while searching in a shape file. The shape file is having about 300000 records.

 

Thanks & Regards

Sanjay Pandey 

6/17/2014 1:07:24 AM
MVP
Total Posts 323

Re: very slow query

Try to export the shapefile to a database by using our utility or any third-party utility, create indexes for the required fields. This way the query can be sent directly to the database by setting the Layer.EnablePassthroughQuery property to true. But, optimizing a query that contains LIKE is a hard task even for database servers.