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
============================================================