[postgis-users] Very long time for a bbox/within query

[Gregory S. Williamson]

David --

Thanks for the tips (and rapid reply!) ... I'll give them a try in a bit. The parcel geometries do tend to to be quite complex; the county shapes are somewhat more regular but still have lots o' vertices.

What I am after is perhaps simply slow to compute ... is any part of any of the data in a given table inside of (within and/or overlaps) with a county boundry. Saying we have data when we don't is not good but tolerable occasionally; saying we do not have data when we do is to be avoided. Perhaps "within" is not the proper beast ?

Greg W.

-----Original Message-----
From:	David Blasby [mailto:dblasby at gmail.com]
Sent:	Tue 7/20/2004 2:42 PM
To:	PostGIS Users Discussion
Cc:	
Subject:	Re: [postgis-users] Very long time for a bbox/within query
Instead of the sub-queries try putting in the actual geometries (run
the sub-queries in psql and copy-and-paste in the results).  If it
runs fast, then its probably running the sub-query multiple times or
the type casting system is getting confused.

Next, I'd try removing the within() clause.  If it runs fast, then
you're spending a lot of time inside the within() function - are your
geometries complex?

dave
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users