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

[Frank Warmerdam]

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.

Hisaji,

Steve and I and talking about incorporating some degree of attribute
indexing into MapServer's shape/dbf support and into OGR over the next
few months but I don't think there is a direct solution now.

If you need good attribute query functionality perhaps you should be
using Postgres/PostGIS?

Best regards,

-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent