jper043
This may not help as I guess you may have already done things this obvious. I will list them because I did not when I did it first:
1. Make sure that you recognise mirror calculations (ie Loc2 to Loc1 picks up data for calculation already done for Loc1 to Loc2) rather than recalculating
2. Create all the location objects before you start the calculation run
3. Consider whether you can live with straightline distance which you then multiply by a fiddle factor (1.2 being the favorite, but you could do a sample of real routes and establish a better factor for your geography). This of course is MUCH faster.
4. Divide the database into multiple parts and run on multiple computers