Re: acceptable number of extents?

David Weis <dweis@louisville-i-market.com> offerred: +Interesting things, those extents. I ran across a table last week that had 274 +extents and when I did the calculations, 235 was the maximum number. I still do +not know how the engine is still running --- must be magic!! Since the max # of extents for a table with NO varchars or blobs and NO indexes whatsoever is 245 for a 2K page size, it must be that you are on a 4K Page system (From what I recall, the sample calculations assume a 2k page size), where the comperable limit jumps to 501. Dave ** Dave Kosenko <davek@summitdata.com> ** Director of Training Services (732) 469-4070 ** Summit Data Group (an Informix Authorized Education Center) ** Find my advice useful? Let me teach you everything I know about ** Informix. Sign up for OFFICIAL Informix training at SDG. ** For details, see http://www.summitdata.com/training