Select to view content in your preferred language

Enterprise ArcSDE Object Limit???

5211
21
03-27-2015 06:37 AM
JerryGarcia
Occasional Contributor II

What is the maximum number of tables/feature classes for an Enterprise GDB? Is there a similar reference for ArcSDE using SQL Server?  http://resources.arcgis.com/en/help/main/10.2/index.html#//018s00000002000000 This is from Microsoft: https://technet.microsoft.com/en-us/library/aa933149%28v=sql.80%29.aspx Thanks!

Tags (2)
0 Kudos
21 Replies
VinceAngelo
Esri Esteemed Contributor

There are too many intrinsic flaws in using a view for this purpose.  If the goal is to give each user/project/anything a virtual set of unique tables, it's far better to give them an actual set of unique tables.

0 Kudos
MartinAmeskamp
Occasional Contributor II

If we're looking at plain ArcMap and a smallish number of tables and users - yes, by all means. On the other hand, I recently came across a situation (no customer of ours) where this approach had resulted in the number of tables being more than 100,000, with thousands of ArcGIS Server services on top. Surprisingly, the system still seems to work...

In the context of our application, this is not an option: The application structure and constraints imposed by Schneider Electric ArcFM prohibit the use of multiple sets of tables in one database. Believe me, we have investigated this rather thoroughly.

Martin

0 Kudos