Hi Francisco,<div><br></div><div>You have relatively low number of records in your database.</div><div>Have you checked for indices on gid, source, target and the_geom?</div><div>And then it's slow to have high ID's. Try to renumber source and target ID's to have them start from 1.</div>
<div><br></div><div>Daniel</div><div> </div><div><br><div class="gmail_quote">On Tue, Sep 6, 2011 at 2:20 AM, Gastón Lucero <span dir="ltr"><<a href="mailto:gaston.lucero@sitrack.com">gaston.lucero@sitrack.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><u></u>
<div text="#000000" bgcolor="#ffffff">
Try using clusters over your geometry column<div><div></div><div class="h5"><br>
<br>
<br>
On 05/09/11 13:32, Francisco Garcia wrote:
</div></div><blockquote type="cite"><div><div></div><div class="h5">
<div>
<div>Hello all, right now I am working in a routing tool,
unfortunately in my server it takes 1.2 seconds in average
every routing. There are any tip/advice or a server
configuration to improve the routing time.</div>
<div><br>
</div>
<div>By the way, I have a 180000 segments network.</div>
<div><br>
</div>
<div>Regards,</div>
<br>
<div>
<div style="word-wrap:break-word"><span style="border-collapse:separate;color:rgb(0, 0, 0);font-family:'Trebuchet MS';font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium">
<div style="word-wrap:break-word"><span style="border-collapse:separate;color:rgb(0, 0, 0);font-family:'Trebuchet MS';font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium">
<div style="word-wrap:break-word"><span style="border-collapse:separate;color:rgb(0, 0, 0);font-family:'Trebuchet MS';font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium">
<div style="word-wrap:break-word">
<div><b>Francisco Garcia </b></div>
<div><b><a href="mailto:franciscog.garcia.rincon@gmail.com" target="_blank">franciscog.garcia.rincon@gmail.com</a></b></div>
<div><b>Movil: (057) <a href="tel:316-331-0936" value="+13163310936" target="_blank">316-331-0936</a></b></div>
<div><br>
</div>
</div>
</span><br>
</div>
</span><br>
</div>
</span><br>
</div>
<br>
</div>
<br>
</div>
</div></div><pre><fieldset></fieldset>
_______________________________________________
Pgrouting-users mailing list
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a>
</pre>
</blockquote>
<br>
</div>
<table><tbody><tr><td bgcolor="#ffffff"><font color="#000000"><pre>Disclaimer:
This email and any attachments thereof may contain confidential, privileged, proprietary, or otherwise private information. This email is intended solely for the use of the individual to whom it is addressed. If you are not the intended recipient of the email and its attachments please inform the sender immediately and do not disclose the contents to any other person, use it for any purpose or store or copy the information in any way and delete this e-mail and its attachments from your system. Any views or opinions expressed are solely those of the author.</pre>
</font></td></tr></tbody></table>
<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"><div><br></div>-- <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>