topic Re: Performance of Network Analyst in different geodatabases in ArcGIS Network Analyst Questions

Performance of Network Analyst in different geodatabases

JanBjurström — Thu, 24 Nov 2011 06:06:57 GMT

Hi,

Anybody who can tell which geodatabase type is the fastest (based on tests or experienced use with same dataset and analyses)? Personal gdb, File gdb or SDE gdb? Talking Single user.

http://resources.arcgis.com/content/enterprisegis/10.0/infrastructure_datasources says all geodatabases have High performance, but I think there should be differences between these database formats regarding performance.

Greatfull for your knowledge
Janne

Re: Performance of Network Analyst in different geodatabases

JaySandhu — Fri, 25 Nov 2011 18:36:03 GMT

Generally speaking, for solving routing problems, a file geodatabase network dataset will have the best performance.
You should also look into the gp tool DissolveNetwork to make a better performing network dataset.
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00480000000w000000.htm
Regards,
Jay Sandhu

Re: Performance of Network Analyst in different geodatabases

AlexeyTereshenkov — Sat, 26 Nov 2011 14:54:32 GMT

Agreed with Jay. File geodatabase shown best performance when solving routing tasks. The GP tool Jay mentioned is incredible: the storage of the data was optimized (I have succeeded compacting my street layer from 1GB to 300MB) and the actual time required for solving has decreased (what I've seen is up to 20% less).

I have used to use the Compress File Geodatabase tool as well - http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00170000004v000000. It makes it possible to optimize the geodatabase storage (my geodatabases with street vector data become like 3 times smaller) and I have not noticed any degradation for the actual routing performance.

Jay, compressing a file geodb does not impact the routing performance negatively, doesn't it?