Indexed Shapefile vs. PostGIS

[Ethan Alpert]

Ok I haven't done attribute filtering but I find that displaying is very
fast. I have a 186,000 record extremely high res world admin shapefile
and QIX saved the day. I only turn this layer on at a resonable scale
(similar to what the original poster said) and it's very fast. 

-e

-----Original Message-----
From: UMN MapServer Users List [mailto:MAPSERVER-USERS at lists.umn.edu] On
Behalf Of Schuyler Erle
Sent: Wednesday, August 24, 2005 4:05 PM
To: MAPSERVER-USERS at lists.umn.edu
Subject: Re: [UMN_MAPSERVER-USERS] Indexed Shapefile vs. PostGIS


* On 24-Aug-2005 at  1:46PM PDT, Ethan Alpert said:
> You can also use shptree to generate a spatial index file (QIX) which 
> mapserver will use to fairly efficiently display the data.

I've found that the QIX support isn't sufficient to speed up access to
really large shapefiles, especially if you're doing any kind of
attribute filtering. I'd love to know why this is.

SDE