Re: Is there a downside to creating large chunks?

Posted in 2008

Obnoxio The Clown — Thu, 17 Jul 2008 21:14:48 +0100 (BST) — source: Usenet: comp.databases.informix

Bent_Andy said: > I am running a Baan ERP system on Informix 11.50/HPUX that has 5800 > tables. I want to spread these across 8 dbspaces. Is there a > disadvantage or advantage to creating 1 chunk per dbspace initially? You *could* get unexpectedly long checkpoints because there isn't enough distribution of data across multiple chunks. -- Bye now, Obnoxio http://obotheclown.blogspot.com/