[Mapserver-users] How to speed up reading Shape files' large DBF

[Paul Ramsey]

Mr. Ono,

The only time the size of the DBF file should affect your mapserver
speed is when you are doing a queryitem query (an attribute-based
lookup). When using a spatial index and drawing a small area, only those
features which are in the map extent are tested against the class
definitions. Have you already built a spatial index? If not, do so, and
see how things go.

If you *do* need to do an indexed attribute-based query, consider using
PostGIS as your data store instead.

Paul

Hisaji Ono wrote:
> Hi.
> 
>  Currently I tried to deal with large-sized DBF files (more than 200MB) of
> ArcView shape files using MapServer 3.6.x on Win XP.
> 
>  It takes about a few minutes to display map with several classes on my PC.
> I'd like to speed up displaying map within 30 seconds.
> 
>  MapServer supports spatial indexing for shape file, but not indexing for
> DBase file.
> 
>  Could someone give any suggestion?
> 
>  Best Regards.

-- 
      __
     /
     | Paul Ramsey
     | Refractions Research
     | Email: pramsey at refractions.net
     | Phone: (250) 885-0632
     \_