Hi Emre,<div><br></div><div>How large is your network?</div><div>I think you could do it faster, but it depends also on your hardware and you might also be able to make some changes in the postgresql configuration.</div><div>
Ride the city for example is using pgRouting and the size of the cities should be comparable to Istanbul:</div><div><meta http-equiv="content-type" content="text/html; charset=utf-8"><a href="http://www.ridethecity.com/">http://www.ridethecity.com/</a></div>
<div><br></div><div><a href="http://www.ridethecity.com/"></a>To improve speed you can check:</div><div><ul><li>Indices for attributes used in your query</li><li>ID numbering (very high ID's make it slow)</li><li>complicated cost calculation and joins between tables. If you have this, maybe you could pre-calculate some costs.</li>
</ul><div>In general as less network data you load with your select as faster it is.</div><div><br></div><div>Daniel</div><div><br></div><br><div class="gmail_quote">2011/2/2 Emre Koc <span dir="ltr"><<a href="mailto:emrekoch@gmail.com">emrekoch@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><font size="2"><font face="tahoma,sans-serif">Hi All,</font></font><div><font size="2"><font face="tahoma,sans-serif"><br>
</font></font></div><div><font size="2"><font face="tahoma,sans-serif">What is the average speed for running a shortest path query over a large city ? For Istanbul it takes about 3.5 seconds to find a path in my setup. I slightly modified sp_smart_directed function and using it right now but I am not sure if the speed is ok. If I reduce delta value for this function (which is limiting the region to be processed) operation is speeding up but it cannot find paths that exceeds the region. </font></font></div>
<div><font size="2"><font face="tahoma,sans-serif"><br></font></font></div><div><font size="2"><font face="tahoma,sans-serif">If my query time is slow what is your suggestion on speeding things up? I added index for the_geom column. Is there anything to be done extra? </font></font></div>
<div><font size="2"><font face="tahoma,sans-serif"><br></font></font></div><div><font size="2"><font face="tahoma,sans-serif">Thanks,</font></font></div><div><font size="2"><font face="tahoma,sans-serif"><br clear="all">
</font></font>/emre<br>
</div>
<br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><span style="font-family:arial, sans-serif;font-size:13px;border-collapse:collapse">Georepublic UG & Georepublic Japan<br>eMail: <a href="mailto:daniel.kastl@georepublic.de" style="color:rgb(66, 99, 171)" target="_blank">daniel.kastl@georepublic.de</a><br>
Web: <a href="http://georepublic.de/" style="color:rgb(66, 99, 171)" target="_blank">http://georepublic.de</a></span><br>
</div>