Re: Maximum extents

Posted in 1997

Valery Fouques — Wed, 15 Jan 1997 21:45:28 +0100 — source: Informix-list mailing list archive (1991-1998)

Mickey Mestel wrote: > > hi, > > > Well, there is no fixed answer because it depends on the table. But > > I've seen 200 in some documentation in the past. > > i think it is in the performance guide, i'm not sure. but no one has > rasied the issue, why do you need to know? you take a performance hit > when the number of extents is greater than 8, more than will fit on one > page. > > the bottom line is that you should do everything you can to make sure > that a table never has more than 8 extents. > > mickm It happened to me once (having more than 200+x extents), and I had to recreate the table. I recommend NOT to let your tables grow so big... -- Valery Fouques valou@hotmail.com SYSADM GOSPORT-FRANCE /\\oO/\\ _ __/| \\`O.o' "355/113 -- Not the famous irrational =(_ _)= number PI, but an incredible simulation!" U