Select to view content in your preferred language

Enterprise ArcSDE Object Limit???

03-27-2015 06:37 AM
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? This is from Microsoft: Thanks!

Tags (2)
0 Kudos
21 Replies
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
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.


0 Kudos