Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 4 of 4

Route comparison speed

This is a discussion on Route comparison speed within the MapPoint Desktop Discussion forums, part of the Map Forums category; I'm creating a console app in C# that will determine the distance between two points. I've got the program working, ...

  1. #1
    sjmorin is offline Junior Member White Belt
    Join Date
    Jun 2004
    Posts
    2

    Route comparison speed

    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

  2. #2
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    You'll be glad to hear C# isn't the cause of your problems
    I've done similar things in C++, and MapPoint is the one that is sucking cpu - so C# overheards are not relevant.

    Two suggestions:

    1.) Cache as much as you can. Route finding is the slow link in the chain, as you are probably aware.

    2.) Are as-the-crow-flies distances relevant?
    Can these be used to prune the more distant routes?
    This could be a double improvement - as well as removing some of the route-finding, these longer routes take the most cpu to find!


    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  3. #3
    sjmorin is offline Junior Member White Belt
    Join Date
    Jun 2004
    Posts
    2

    Caching MapPoint Data

    Thanks for the reply. I was wondering what type of data should I be caching. Also the "as the crow flies" distances won't work, I have to know the exact driving distance and driving time in this application.

    One more thing, is there any way to update the zip codes in MapPoint. I've got some that I know exist but MapPoint cannot retrieve any information on them. Thanks

    Scott

  4. #4
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    No you can't update the zipcodes.

    re. "as-the-crow-flies" I was wondering if you could do this as a quick test - eg. not do a proper route test between two locations that are far away, because there's no chance of the driving time being within range.

    caching: depends on your application: eg. are particular routes being tested regularly?



    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Route distance processing speed
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 6
    Last Post: 03-07-2005, 12:36 PM
  2. Speed of the service
    By sbedin in forum Bing Maps and MapPoint Web Service
    Replies: 0
    Last Post: 12-21-2004, 11:13 AM
  3. Excel VBA or VB6 For Speed
    By DavidP in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 08-14-2004, 06:50 PM
  4. Automate Comparison of Zip Codes before Import vs. Mapped
    By pherschmann in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 01-26-2004, 03:26 PM
  5. Change the Speed and the route changes -Can this be stopped?
    By mizzy in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 09-09-2003, 05:49 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25