[postgis-users] advice for quicker display?

[Puneet Kishor]

On Feb 14, 2012, at 12:57 PM, Bistrais, Bob wrote:

> As some of you already know, I'm a newbie to PostGIS and have just
> barely got a test PostGIS database up and running.  So, my latest
> question is in regards to draw times.  I created a statewide parcel
> layer from a shapefile.  At statewide scale, when the application loads,
> the parcel data draws far slower than the original shapefile did.  How
> can I tune this so that draw times are better?


for starters, do you have a GIST index on the geometry column?



--
Puneet Kishor