[Qgis-developer] Query performance in QGIS using psycopg2

2015-05-12 Thread McDonaldR
Hello list I have a question about how QGIS (specifically the pgRouting Layer plugin) uses psycopg2 and a connection to PostgreSQL to run a query and return a result. I am using pgRouting with Ordnance Survey's Open Roads network for the UK. It is a large network with over 3 million links and

Re: [Qgis-developer] Query performance in QGIS using psycopg2

2015-05-12 Thread Alex Mandel
Start by using Explain SELECT ... And compare to see if the query planner is running the same way. Thanks, Alex On 05/12/2015 02:33 AM, McDonaldR wrote: Hello list I have a question about how QGIS (specifically the pgRouting Layer plugin) uses psycopg2 and a connection to PostgreSQL to run