Seven hours ago I was fast asleep. Just to make sure, you have the following problem: 1. Origin point and departure date/time. 2. Destination point. 3. A schedule table of boarding and target stops with dates and times. And so you want to find the fastest route between Origin and Destination points...regardless of how many stops there are between? If this is the case, I'd suggest you provide an example from your data. Show us the origin record and the trip records you or someone has manually determined to be the optimal route (assuming this is a process that currently exists at all). You'll have to do QA on your logic at some point in time, otherwise you won't be able to prove to anybody that your coding is successful, right?
... View more
