Re: Number of extents in an instance

mdevlin8648@my-dejanews.com wrote: > > How many extents are exceptable? with multiple extents how drastically is > performance reduced? our databse consists of around 200 tables, 9 of which > have over 100 extents and about 40 have more than ten. I am very new to > informix and am trying to tune our configuration for better performance. > could these large number of extents be haveing a major performance impact? > Any help would be greatly appreciated. Is it possible to unload, drop, and recreate those tables? I try to keep the number of extents less than 8 on any given table. This would reduce latency (?) by not requiring a large amount of read/write head movement. John Carlson Informix DBA WH Smith, Inc.