RE: Is there a downside to creating large chunks?

Posted in 2008

Campbell, John (GE Money) — Thu, 17 Jul 2008 17:38:56 -0400 — source: Usenet: comp.databases.informix

-----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Sebastian, Norma J. Sent: Thursday, July 17, 2008 5:25 PM To: Bent_Andy Cc: informix-list@iiug.org Subject: RE: Is there a downside to creating large chunks? I know this isn't your question... But how big is your database? How many dbspaces do you have now? And how do you do your backups? Increasing or decreasing the number of dbspaces can impact your backup performance. I ask because I used to run SAP on informix using onbar for backups... The more dbspaces I had, the more I could parallelize my backup. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Obnoxio The Clown Sent: Thursday, July 17, 2008 3:15 PM To: Bent_Andy Cc: informix-list@iiug.org Subject: Re: Is there a downside to creating large chunks? 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/ _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================ _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list May be worthwhile to consider parallel data queries and table fragmentation as well.