<div class="gmail_quote"><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="gmail_quote"><div class="im"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="gmail_quote"><div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">This is really not many ways. It should be a lot faster.</blockquote></div><div><ul><li>
Did you check your tables have indices?</li>
</ul></div></div></blockquote></div><div><br>All the tables have indices. Are there any special requirements to particular tables to have indices? <br></div></div></blockquote><div><br></div><div>It's good to have indices for attributes you use in your select. For example, if you select by bounding box, you should have an index on your geometry column.</div>
<div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="gmail_quote"><div class="im"><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
<div class="gmail_quote"><div><div><br></div></div><div>The bottleneck is the number of ways you select from the table. </div>
<div>You can improve your speed by selecting less road links.</div></div></blockquote></div><div><br>I am sorry, but I don't really understand what 'road links' mean in pgRouting parlance. There are vertices which are built from OSM nodes, there are ways which are extracted from OSM multi-line ways. How road links are represented and in which table?<br>
</div></div></blockquote><div><br></div><div>The vertices table is only a temporary table which is not used for pgRouting. It's used for building the topology.</div><div>The relevant table is "ways" of geometry type LINESTRING (or MULTILINESTRING). These are road segments, which some people call "edge", some "link".</div>
<div><br></div><div>Daniel</div><div><br></div></div><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>