Loading speed

Posted in 2000

Thomas Stainer — Thu, 29 Jun 2000 10:25:16 +0200 — source: Informix-list mailing list archive (1991-1998)

Running IDS 7.30 UC6 on a 4CPU HP9000 (HP-UX 10.20), we have every now and then to load larger tables (some 2 - 5 million rows) and create some indexes on them. Before doing this we turn the logging mode from unbuffered to no logging, we increase checkpoint intervals but nevertheless load takes a very long time. Does IDS 7.* already has the High Perfomance Loader (I guess no)? How can I speed up the loading process? thanx for every useful advice ------------------------------------------------- Thomas Stainer - tstainer@styria.com