[postgis-users] Distance() vs ? - performance

[Paul Ramsey]

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
      \_