Abraham Kirubakaran wrote:

> As a general rule, make sure you don't exceed more
> than 8extents per fragment for a table, this helps
> performance.

The 8 extents general rule applies to OnLine up to and including version 5.
From version 6, all extents are cached, so there is no real drop in
performance in terms of tracking extents after 8 extents. However, 1 extent
per fragment is best. If you get any were near 200 then you run the risk of
running out and getting errors. Any where in between and it depends on the
type of user access as to the affect on performance.

Cheers,
--
Mark.

+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /|
| Mydas Solutions Ltd http://MydasSolutions.com |///// / //|
| +-----------------------------------+//// / ///|
| |We value your comments, which have |/// / ////|
| |been recorded and automatically |// / /////|
| |emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+

sending to informix-list