ER replicate compressed tables

Posted in 2015

Topics: Performance & Tuning, Logging & Checkpoints

FRANK — Wed, 15 Jul 2015 19:01:07 — source: IIUG Forums & Mailing Lists

Folks, IDS12.10 FC4 If a table is replicated, How would it impact ER performance ( positively or negatively or ..) if we compress the table? Another question, If the table is compressed at one site only, ER will send the compressed data in the format in logical log and do un-compression in another site, correct or not? Thanks Frank --001a1135a2d494bd05051aee93f8

↪ replying to FRANK

Madison Pruet — Wed, 15 Jul 2015 20:37:03 — source: IIUG Forums & Mailing Lists

It is transmitted in uncompressed format. The overhead is basically the same as doing a select from a compressed table. From: "FRANK" <yunyaoqu@gmail.com> To: ids@iiug.org Date: 07/15/2015 02:01 PM Subject: ER replicate compressed tables [35468] Sent by: ids-bounces@iiug.org Folks, IDS12.10 FC4 If a table is replicated, How would it impact ER performance ( positively or negatively or ..) if we compress the table? Another question, If the table is compressed at one site only, ER will send the compressed data in the format in logical log and do un-compression in another site, correct or not? Thanks Frank --001a1135a2d494bd05051aee93f8 ***************************************************************************= **** Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary

logical log