[postgis-users] finding items in polygon and sorting

[Robert Burgholzer]

You may also see an improvement in the speed if the sort column is an
integer with the time translated into seconds since the unix epoch.


On Tue, 2005-10-11 at 02:37, strk at refractions.net wrote:
> An index on the date column should help sort, check 
> explain output with and w/out the index.
> --strk;
> 
> On Tue, Oct 11, 2005 at 12:22:15AM -0400, douglass_davis at earthlink.net wrote:
> > 
> > Lets say if I want to find some items in a polygon and sort them...  For 
> > example, all the "points" in Georgia, sorted by date of creation (also 
> > in database).  There could be thousands of points.  I know that a 
> > spatial index will help me find what's in Georgia, but is there any way 
> > to make the subsequent sort faster?
> > 
> > I didn't know if this was possible, but just asking.
> > 
> > -- 
> > http://www.douglassdavis.com
> > 
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
-- 
Non-point Source Data Analyst
University of Maryland, College Park
Chesapeake Bay Program Office
410 Severn Avenue, Suite 305B
Annapolis, MD, 21403
Phone: (410) 267-5779

rburghol at chesapeakebay.net