I'm creating a console app in C# that will determine the distance between two points. I've got the program working, but it takes an extremely long time to process it. Here's how it works:
The program retrieves a list of distributors from a sql table. This table has the distributors zipcode, maximum driving time, address, and state in it. The end point is already calculated and added to the route, this happens each time the application is ran for the first time. The system loops through the distributors and compares the route driving time to the distributors maximum driving time (from the table). The loop continues until a distributor is found whose max driving time is less than or equal to the route driving time.
I was wondering if there was a better/quicker way of doing this. My company plans on having a dedicated server that will do all of the mappoint processing on it.
Thanks for your help in advance.
Scott