conditional/regular expressions are slow
Dylan Keon
dbkeon.ml at GMAIL.COM
Fri Aug 5 17:48:29 PDT 2005
On 08/05/2005 05:07 PM, Douglass Davis wrote:
> Also, the highways are numbered A1.* and A2.* for the big highways A3.*
> for the smaller highways etc. So, What I do is use regular expressions
> like:
>
> EXPRESSION /A[12].*/
> EXPRESSION /A[3].*/
>
> This appears to be slowing things down. What's the best way to handle
> this?
I haven't tested this, but I wonder if /^A[12]/ and /^A3/ would be any
faster.
> Three ideas I have for speeding this up are:
> 1. Export the shapefile to PostGIS where it can be indexed correctly
> 2. Separate the shapefile into multiple shapefiles somehow. One file
> would have big cities, the next file would have medium size cities and
> big cities etc.
> 3. Somehow add more indexing to the shapefile.
Try creating spatial indexes on your shapefiles if you haven't done so
already. Use the shptree utility that is packaged with MapServer.
--Dylan
More information about the MapServer-users
mailing list