I would like to run a batch process to derive the total driving distance between points, for a largish set of point-pairs.
e.g. I would have data something like:
Start_ID Start_Lat Start_Long Dest_ID Dest_Lat Dest_Long
00000001 42.12345 -76.54321 10000000 41.12345 -75.54321
What I would like to get returned from this is the driving distance.
I have tried this using a few web services, but the latency is such that it would take too long for my purposes. I have potentially millions of routes to compute, so a latency of a couple seconds quickly adds up to way too much! :)
I have seen some references to setting up an OSRM instance as well as other references to PostGIS with pgRouting. I don't know these tools, so I am not sure if they would meet my requirements or if there is another tool that would be better.
So, what good solutions exist for generating total driving distance for many pairs of points, to execute in batch mode?