Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have a SDE 10.0 Geodatabase based on MS SQL 2008.

I'm running a continuous process where about 6400 point features are written to a feature-class every hour. I need it to be a featureclass, since I'm doing some krigging on the feature-class, after applying an attribute query based on a time field in the data.

I was wondering what is the limitation on the number of features a SDE Feature-class can hold?

share|improve this question
    
2  
@radouxju This is not a duplicate as that question talks about File Geodatabse, and none of the answers talk about max number of features in a SDE Featureclass –  Devdatta Tengshe Jan 17 at 11:29
1  
@ devadatta : my mistake, sorry –  radouxju Jan 17 at 11:43
add comment

2 Answers

up vote 9 down vote accepted

Two billion features, plus or minus (2^31-2 legal rowid values). I've only loaded 80m personally, but a colleague used my tools to load 680m in Oracle, SQL-Server, and PostgreSQL servers, side by side. That said, the effective useful limit is a lot closer to 20-50 million features.

Tables loaded over time are extremely vulnerable to the effects of spatial fragmentation, which will destroy spatial-first query performance in tables over 2 million rows. If you plan to let the table grow unbounded, you'll need to implement a mitigation plan.

There are an infinite number of permutations of database product, geometry storage, versioning status, and insert behavior which could limit row count -- 2^31-7 versioned edits of an SDEBINARY layer would limit the business table to 5 rows.

For your use case of simple feature insert, the limit is "two gigafeatures". Once you start moving features, then you run into a different limit -- "the total number of features a layer has ever held since the last TRUNCATE" (which is also two gigafeatures). This is probably why "the limit" is not documented.

share|improve this answer
    
Thanks! Can you give a source citation for the number? We are in the process of periodically moving to different tables, but we are debating whether we should do it monthly, bimonthly, or quarterly. –  Devdatta Tengshe Jan 17 at 11:59
1  
You need a source for the maximum value of a signed 32-bit integer? –  Vince Jan 17 at 12:19
    
I need a source that 32 bit integer limit for the ObjectId is the limiting factor, and not something else. –  Devdatta Tengshe Jan 17 at 12:22
1  
As an clarification to my last comment, imagine this situation. Supposed it is a Versioned fc. Maybe the A & D tables have some effect on the limitation. (I don't know if it's true, just an example of what could be a limiting factor) –  Devdatta Tengshe Jan 17 at 12:29
3  
There are an infinite number of permutations of database product, geometry storage, versioning status, and insert behavior which could limit row count -- 2^31-7 versioned edits of an SDEBINARY layer would limit the business table to 5 rows. For your use case of simple feature insert, the limit is "two gigafeatures". Once you start moving features, then you run into a different limit -- "the total number of features a layer has ever held since the last TRUNCATE" (which is also two gigafeatures). This is probably why "the limit" is not documented. –  Vince Jan 17 at 14:56
add comment

Starting from 10.1 the new 64 bit version will allow you to store and index up to 2^64 records theoratically. That's alot.

Of course you have to enable geodatabase archiving if you are aiming this high.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.