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.