I have no programmer's background therefore, I try to avoid use python scripting, however If I there is no other choice I am willing to improve my skills.

My question is how to improve performance on OD Cost Matrix for 200,000 origins and 1,000 destinations i.e. finding a way to improve the performance on OD cost matrix analysis on ArcGIS 10.0?

I use ArcSDE with postgresql and keep my origins and destinations on the database. I have uploaded 200.000 origins in about 75 minutes and it took minutes to load the destinations.

Currently I have waited around half an hour and my work seems to progress around 0%. However It is not crashed yet and according to the status bar it jumps to another location every 5-10 seconds.

It seems to be I am doing something very wrong. Do you have any advises to improve performance or at least make sure that my calculations will not crash?

I can only divide origins to smaller parts, I will have to keep my destinations all together.

2 Answers 2


Normally route calculations are done as 1-to-many, which means it is faster to calculate from one destination to your 200,000 origins, because that only have to be done 1000 times as opposed to 200,000 times. If it is important to you that the routes are calculated from origin to destination, you will have to swap all oneway restrictions temporarily (because a route from A to B isn't always the same as B to A).

Size of the street network also matters a lot. How many records does your underlying street network have?

Right now you are looking at 7.5sec x 200,000 = 25,000 min = 416 hours = 17 days.

  • I have around 17 Million records on my street network which is actually whole Turkey. According to your calculation I need to improve the analysis performance around %75, as I have to do this analysis every month in 5 days period upon dataset delivery.
    – Celik A
    Mar 30, 2012 at 11:40
  • Are you sure about this? A street network for the UK with all details are around 4 million records Mar 30, 2012 at 15:42
  • Turkey is a big country :) Beside, sea transportation is included on this dataset.
    – Celik A
    Mar 30, 2012 at 19:44
  • Not that big. What is your data source? Anyway, I know it can be done several orders of magnitude faster with the software I sell (www.routeware.dk), but I don't know if NA is really that slow or you are doing something wrong, besides what I have already pointed out. Your street network may be one of them. Mar 31, 2012 at 7:01

If anyone interested, I was only keeping my network dataset and origin file in ArcSDE, I have also imported my destinations to SDE and deleted all unnecessary fields which are stored within my tables yet, I or ArcGIS Network Analyst do not need and I got faster data upload rates now.

Beside, I just realised that I would not use the lines that Network Analyst Rendered, so I have just disabled them before the analysis and the anaysis has been completed even faster. (10 to 20 X faster I believe)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.