RE: acceptable number of extents?

M, The recommendation from Informix is no more than eight extents. I personally don't allow more than three extents. If the table is very large it can span multiple chunks, the table will then have multiple extents that can't be eliminated. If you use a fragmentation strategy the table will be listed with multiple extents. My final piece of advice on this subject, after advice from Art, is that you don't need to worry about extents on the system tables. Regards David Ashby -----Original Message----- From: mdevlin8648@my-dejanews.com [mailto:mdevlin8648@my-dejanews.com] Sent: Friday, 14 August 1998 3:57 To: informix-list@iiug.org Subject: acceptable number of extents? our database has over two hundred tables, 9 of them have more than one hundred extents and another 35 have over 10. how signifigantly could this impact performance? I am new to informix and attempting to tune our configuration. Any help would be appreciated. -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum