Re: acceptable number of extents?

Hey Dave, yeah, I thought so too on the 4K pagesize, but when I checked the configuration file and the logical logs, the pagesize was only 2K. Like I said, it MUST be magic, huh? I just hope the magic does not end until AFTER I get the table unloaded....... David Kosenko wrote: > 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 -- David Weis Louisville Internet Marketing Services dweis@louisville-i-market.com 1425 South First Street Louisville, KY 40208 USA 502-637-7316 (Voice) 502-636-1553 (FAX)