<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Dear all,<div><br></div><div><p style="margin-bottom: 1em; border: 0px; font-size: 14px; vertical-align: baseline; clear: both; word-wrap: break-word; color: rgb(51, 51, 51); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 18px; background-color: rgba(248, 248, 248, 0.6);">I need to obtain a set of nearest nodes from a given location (maybe 30 or 40). Then I need to calculate the shortest path from the given node from each others. It means to execute shortes_path query multiple times in a row, wich takes about 2 seconds (1 query 2 seconds: 30 queries 60 -> too long).</p><pre class="lang-sql prettyprint prettyprinted" style="margin-top: 0px; margin-bottom: 10px; padding: 5px; border: 0px; font-size: 12px; vertical-align: baseline; overflow: auto; width: auto; max-height: 600px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; background-color: rgb(238, 238, 238); color: rgb(57, 51, 24); line-height: 18px;"><code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; color: rgb(34, 34, 34);"><span class="kwd" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(138, 74, 11);">SELECT</span><span class="pln" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: black;"> </span><span class="pun" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(20, 86, 128);">*</span><span class="pln" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: black;"> </span><span class="kwd" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(138, 74, 11);">FROM</span><span class="pln" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: black;"> shortest_path</span><span class="pun" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(20, 86, 128);">(</span><span class="str" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: maroon;">'
SELECT id AS id,
source::int4 AS source,
target::int4 AS target,
cost::float8 AS cost
FROM tt_2po_4pgr'</span><span class="pun" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(20, 86, 128);">,</span><span class="pln" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: black;">
</span><span class="lit" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(149, 56, 56);">275742</span><span class="pun" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(20, 86, 128);">,</span><span class="pln" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: black;">
</span><span class="lit" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(149, 56, 56);">274494</span><span class="pun" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(20, 86, 128);">,</span><span class="pln" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: black;">
false</span><span class="pun" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(20, 86, 128);">,</span><span class="pln" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: black;">
false</span><span class="pun" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(20, 86, 128);">)</span></code></pre><p style="margin-bottom: 1em; border: 0px; font-size: 14px; vertical-align: baseline; clear: both; word-wrap: break-word; color: rgb(51, 51, 51); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 18px; background-color: rgba(248, 248, 248, 0.6);">What would be the best way to do this in a reasonable time?</p><p style="margin-bottom: 1em; border: 0px; font-size: 14px; vertical-align: baseline; clear: both; word-wrap: break-word; color: rgb(51, 51, 51); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 18px; background-color: rgba(248, 248, 248, 0.6);"><br></p><p style="margin-bottom: 1em; border: 0px; font-size: 14px; vertical-align: baseline; clear: both; word-wrap: break-word; color: rgb(51, 51, 51); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 18px; background-color: rgba(248, 248, 248, 0.6);">Thank in advance!</p><p style="margin-bottom: 1em; border: 0px; font-size: 14px; vertical-align: baseline; clear: both; word-wrap: break-word; color: rgb(51, 51, 51); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 18px; background-color: rgba(248, 248, 248, 0.6);"><br></p><p style="margin-bottom: 1em; border: 0px; font-size: 14px; vertical-align: baseline; clear: both; word-wrap: break-word; color: rgb(51, 51, 51); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 18px; background-color: rgba(248, 248, 248, 0.6);">Pd: excuse my english</p></div> </div></body>
</html>