network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 3 months |
| seen | Mar 26 at 8:45 | |
| stats | profile views | 46 |
|
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? |
