Informix

Pipes & light appends

  • 1.  Pipes & light appends

    Posted Wed July 29, 2020 10:52 AM

    IDS 12.10.FC12W1; AIX.

    Working on a large reorg and testing with disk and pipes via the ploader (external tables). As expected, I see light appends when using disk during load, but not when using pipes. Using pipes, the unload/load data never hits the ground as it's cloning rows from source table to target table. The bufferpool mgmt overhead is deadly without light appends. The difference in duration is significant. Some details: ploader; format=informix; type=express; datafiles (pipe or disk)=8; fifovps added if PIPE; 20M'ish rows; format=delimited if DISK, informix if PIPE. Anyone feel that light appends aren't possible using pipes? 

    Thanks - 

    Mark Scranton
    The Mark Scranton Group
    mark@markscranton.com



    ------------------------------
    Mark Scranton
    ------------------------------