[postgis-users] itemnquery limitation

chodgson@refractions.net chodgson@refractions.net
Fri Aug 8 17:43:30 2003


Quoting Zamil Murji <Zamil.Murji@divestco.com>:

> Could be related to the the bug tom is experiencing. For the time being, I
> pulled a shapefile from my postgis layer and am querying that. Speeds are
> horrendous for displaying it though, so I'm stuck wiht two sources of data (a
> postgis for display and a shapefile for querying).

It shouldn't be that slow to render the shapefile... unless it is huge? You do 
have a quad-tree index on it, right? My experience has been that shapefiles are 
faster than postgis (but obviously less flexible).

(http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?ShpTree)


Chris