First of all this is my first question on this site :) And I am really happy to be within the community.
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 as stated on the title, 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.
As I try to follow "one cup of coffee rule", 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.
Kind Regards, Anil.