compression and ER

Folks, When a table is compressed and ER replicated, assume the data compression ratio is 80% on the table, do you think the ER data volume in network for that datable could be reduced by 80%? or compression will not change ER traffic volume ? Thanks, Frank --001a11c2f4e6312cd104f3ddf116

Using the CDR_NIFCOMPRESS in the ONCONFIG file, you control the level of compression that ER uses to transmit data from one server to another. If you are already using CDR_NIFCOMPRESS the gain in ER throughput dependent on compression will depend on the current level of CDR_NIFCOMPRESS already set. If you have it set to 9 there may be on effect whatever (or even a small net negative effect). Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Mar 5, 2014 at 10:47 AM, FRANK <yunyaoqu@gmail.com> wrote: > Folks, > > When a table is compressed and ER replicated, assume the data compression > ratio is 80% on the table, do you think the ER data volume in network for > that datable could be reduced by 80%? or compression will not change > ER traffic volume ? > > Thanks, > Frank > > --001a11c2f4e6312cd104f3ddf116 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0158b70af64de104f3de1357

It will not affect the network. If you want to compress the network traffic, you need to turn on CDR_NIFCOMPRESS on both the source and tar= get nodes. BTW, CDR_NIFCOMPRESS has been in place since version 9.3. M.Pruet = From: "FRANK" <yunyaoqu@gmail.com> = = To: ids@iiug.org, = = Date: 03/05/2014 09:57 AM = = Subject: compression and ER [32650] = = Sent by: ids-bounces@iiug.org = = Folks, When a table is compressed and ER replicated, assume the data compressi= on ratio is 80% on the table, do you think the ER data volume in network f= or that datable could be reduced by 80%? or compression will not change ER traffic volume ? Thanks, Frank --001a11c2f4e6312cd104f3ddf116 ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =