[postgis-users] Distance() vs ? - performance
Paul Ramsey
pramsey at refractions.net
Tue Feb 17 16:58:43 PST 2004
Tyler,
This is probably one of those cases where a fuller explanation of your
problem would help. What are you calculating distances *for*, what are
your inputs, desired outputs, general description of the problem. It is
possible that a different approach to your problem could yeild a better
result.
Paul
Tyler Mitchell wrote:
>
> Dave answered my question earlier, but now I'm wondering if there is a
> trade-off on memory/temp space usage.
>
> I'm trying to compute a distance between two tables of features and find
> my temporary files fill up the drive and kill my query.
> My query involves computing the distance from polygon features to the
> nearest line feature (i.e. polygons -> road line). So I can't use && to
> optimize the query because they are very discontiguous.
>
> Any recommendations?
>
> postgis-users-bounces at postgis.refractions.net wrote on 02/13/2004
> 01:19:12 PM:
>
> >
> > I'm doing some basic computing of distance between geometries and
> > I've traditionally used Distance() to give me what I want. With
> > geos integration is there a different, higher performance option
> forme to use?
> > Suggestions?
> >
> > Tyler_______________________________________________
> > 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
--
__
/
| Paul Ramsey
| Refractions Research
| Email: pramsey at refractions.net
| Phone: (250) 885-0632
\_
More information about the postgis-users
mailing list