RE: Whatcha' wanta have?????

> -----Original Message----- > From: Data Goob [mailto:datagoob@hotmail.com] > > Alexey Sonkin wrote: > > This limitation comes from the fact that Informix > > is using 32-bit rowid's, where 24 bits are dedicated > > to the page number (this is where 16 mln page limitation > > comes from)and 8 bytes to the slot number > > (that is, max 256 slots per page) > > > > Interesting, that the same limitation exists in DB2. > > They also use 32-bit ROWID's. And, unlike Informix, > > this limitation can't be overcomed with fragmentation: > > there is no fragmentation in DB2. The only workaround > > is to increase the page size for the particular table, > > so that You can really fit 4 billion rows into it. > > > > Oracle is using 6-byte ROWID's (AFAIK). > > They do not have this limitation... > > > > What about MS SQL? Anybody knows? > > > > ------------------------------------------ > > Alexey Sonkin > > > > > > > A small correction on DB2 'fragmentation': > > DB2 does partitioning, which is functionally equivalent to > "fragmentation" in Informix. Do not agree. Fragmentation can be used for both DSS and OLTP, while partitioning is mostly designed only for DSS systems. The biggest problem of the inter-server partitioning (or inter-instance partitioning in DB2 terminology) is the necessity to synchronize insatance cache's over the slow (compared to memory access) network connection. Also, DB2 partitioning is not 'out of box' from the licensing point of view The interesting thing is that > you can get partitioned clustering out-of-the-box with DB2, > you can't get that with Informix, unless you buy XPS, and god > only knows if XPS is even being used anymore. Of course I'm > talking about DB2 EEE, not workgroup. Partitioning in DB2 is > also somewhat advanced in that it is not just disk partitioning, > but also instance partitioning, something close to what XPS > can do with virtual co-servers on one platform. The difference > is that the partitioning on DB2 is still within one instance, > it's not several instances as in XPS if you set up several > coservers on one platform. XPS is somewhat primitive compared > to DB2 in that regard ( or maybe 'simple' is a better word ). XPS is primitive? I can just remind You once again, that XPS supports HYBRID fragmentation, which is not supported in DB2 yet > Pity XPS never made it into the mainstream, a classic case of > sitting on your assets. > > With DB2 you get today what "arrowhead" was supposed to be, you > don't have to wait for it. You also get table-level memory > management with DB2, with Informix you do not, you get global > instance-wide memory and a handful of other settings and that's > it. > > Regarding MS-SQL, it only runs on Windows, so whatever platform > it runs on, typically Intel x86, it will be limited by whatever > limitation comes with 32-bit x86. Platform limitation has nothing to do with the ROWID limitations. Oracle ROWID is 6 bytes even on 32-bit platforms Pages are typically 4K in > MS-SQL, but can be changed--and I don't recall off the top of > my head what circumstances or limitations there are with that. sending to informix-list