Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
1 9
Impact
~7k people reached

  • 0 posts edited
  • 0 helpful flags
  • 4 votes cast
Feb
10
awarded  Commentator
Feb
10
comment How to make pgRouting faster?
My client has system for vehicle tracking, so he needs routing for cost optimisation. He wants me to make routing as Google has. Google is extemely fast, so my job is to be the same as Google :) Google has avoid tolls, avoid higways, fastest, shorthest route.
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?