<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">By stored procedures what do you mean exactly? Do you mean in a Perl script or something similar?<br><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: Mark Cave-Ayland <mark.cave-ayland@ilande.co.uk><br>To: PostGIS Users Discussion <postgis-users@postgis.refractions.net><br>Sent: Thursday, 26 July, 2007 2:47:27 PM<br>Subject: Re: [postgis-users] Performance Help<br><br><div>On Thu, 2007-07-26 at 11:51 +0000, Alan Cunnane wrote:<br>> I have actually already looked at PG routing however because of the<br>> constraints of this particular project I cannot use it. I have to use<br>> SQL queries as I was attempting however it
seems that the query runs<br>> smoothly enough up until the 8th or 9th table is added to the join. Is<br>> this my own fault in the query or is this just the performance of<br>> Postgresql in handling a large number of joins? I do appreciate your<br>> help and advice,<br>> <br>> Alan<br><br>Tricky :(<br><br>I guess the only thing you can do in that case is check the query plans<br>just before and just after the point at which the query plan<br>deteriorates and try and spot the difference.<br><br>Are you allowed to use stored procedures for your solution? Due to the<br>recursive-type nature of some of the queries you will need, it may be<br>possible to come up with something more efficient that way.<br><br><br>HTH,<br><br>Mark.<br><br>-- <br>ILande - Open Source Consultancy<br><a target="_blank" href="http://www.ilande.co.uk">http://www.ilande.co.uk</a><br><br><br>_______________________________________________<br>postgis-users mailing
list<br>postgis-users@postgis.refractions.net<br><a target="_blank" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br></div></div><br></div></div><br>
<hr size=1>
Yahoo! Answers - Get better answers from someone who knows. <a
href="http://uk.answers.yahoo.com/;_ylc=X3oDMTEydmViNG02BF9TAzIxMTQ3MTcxOTAEc2VjA21haWwEc2xrA3RhZ2xpbmU">Try
it now</a>.</body></html>