Archive - Apr 16, 2012

Date

How to enable automatic compression when loading empty table

Loading an empty table with compressed data is not trivial. In order for Informix to build the compression dictionary, the table must contain some data but in the case of an empty table, there is no data.  To help solve this problem, we can utilize the database scheduler to monitor a specific table such that when it contains enough rows, a compression dictionary will be built so that the remaining rows inserted into the table will be compressed.

eherber's picture

Two new videos: Informix Warehouse Accelerator and Informix Genero

There are two new marketing videos covering Informix available on YouTube:

Informix Warehouse Accelerator

Informix Genero

eherber's picture

Chat with the Lab: Good Practices and Performance on ETL in Informix

Title: Good Practices and Performance on ETL in Informix
Date: Thursday, April 19, 2012
Time: 10:30 AM - 12:00 PM (Central Time), 16:30h Germany
Presented By: Veronica Gomes - Software IT Specialist (IBM)
Registration: Good Practices and Performance on ETL in Informix

Description: