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. > >-----== Posted via Deja News, The Leader in Internet Discussion ==----- >http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum I try to keep my extents at 8 or less. It keeps the disk heads from moving as much when accessing the table. Also, with the 5.x engine, I belive that when the number of extents exceeded 8, it caused an extra I/O to be done. I'm not sure if that's true with the 7.x engine. ___________________________________________________________ Jay Aymond