[mapserver-users] Image Speed Questions---Generic

[Walt Lin]

On the note of trivial rejection and tileindices, what about this solution: store the extents of all the different shapefiles (perhaps one per county on a national level) in a postgres table with an R-Tree index.  When a request comes in, query Postgres for all the shapefiles that intersect and load them using mapserver.  Of course, POSTGIS would be optimal, storing everything in Postgres, but from what I've heard this is really slow in practice.  Thoughts?

Walt