I am working on a app that automates the process of getting route distances between zip codes in vb.net. I have code that works, however it is quite slow (26 minutes for 230 records on a fast computer). I am trying to find distances from 41,000 some zip codes per division of my company(3 total), and update a database witht he distance information. I know the speed isn't database related because i have taken out part of the code where it update the database. Here is an example of how i find the route distance.
objRoute = map.ActiveRoute
objRoute.Waypoints.Add(map.FindAddressResults(, , , , div, ).Item(1))
objRoute.Waypoints.Add(map.FindAddressResults(, , , , zip, ).Item(1))
objRoute.Calculate()
distance = objRoute.Distance
This code produces the results I want but it is really slow.
Thanks,
Tony