109 reputation
8
bio website
location
age
visits member for 2 years, 5 months
seen Mar 26 '13 at 8:45

Feb
10
comment How to make pgRouting faster?
Let say from 180 sec to 4 sec ... much faster!!!
Feb
10
comment How to make pgRouting faster?
Should I also create inidices for time, length, cost,reverse_cost ?
Feb
10
comment How to make pgRouting faster?
My data SRID is 4326. Gid is PK. Source and target did not have index, so I create indices and it is much faster now, thank you for this. When creating route I have 2 types: fastest and shothest, also I have 2 checkboxes: avoid tolls, and avoid highways. So filtering network table depends on user demand. In network table I have 4 fields: time, length, cost and reversse_cost (last 2 depends on oneway)
Feb
10
comment How to use pgRouting's dijkstra_sp_delta_directed with WHERE clause?
It is not simple as that. When creating route I have 2 types: fastest and shothest, also I have 2 checkboxes: avoid tolls, and avoid highways. So filtering network table depends on user demand. Also, my cost field is time in first case and length in second case, so I have to change that field also.
Feb
10
comment PostgreSQL / PgRouting syntax error
Steve, thank you, thank you, thank you ...This was my nightmare
Feb
9
revised How to make pgRouting faster?
edited body
Feb
9
comment How to use pgRouting's dijkstra_sp_delta_directed with WHERE clause?
I tried with views, it is slow ....I tried also with dijkstra_sp_delta_directed (without where clause) and it is slow :(
Feb
9
asked How to make pgRouting faster?
Feb
9
revised PostgreSQL / PgRouting syntax error
added 435 characters in body
Feb
9
awarded  Editor
Feb
9
revised How to use pgRouting's dijkstra_sp_delta_directed with WHERE clause?
deleted 788 characters in body
Feb
9
asked PostgreSQL / PgRouting syntax error
Feb
9
comment How to use pgRouting's dijkstra_sp_delta_directed with WHERE clause?
Anita, thank you ... I was thinking so ...PgRouting is so poorly documented , I am pretty frustrated :(
Feb
8
awarded  Student
Feb
7
asked How to use pgRouting's dijkstra_sp_delta_directed with WHERE clause?