RE: Speeding up DBIMPORT

Posted in 2000

John Carlson — Mon, 28 Aug 2000 13:31:57 -0400 — source: Informix-list mailing list archive (1991-1998)

Might want to look at PDQ to speed up index builds, especially for detached indices. Also, you might want to set up a separate ONCONFIG file for this purpose and reference it for dbimports, etc. > -----Original Message----- > From: remove (_at_) to reply [mailto:mips_at_@zg.tel.hr] > Sent: Monday, August 28, 2000 8:41 AM > To: informix-list@iiug.org > Subject: Speeding up DBIMPORT > > > I am planing to do dbexport/drop database/dbimport. > Tables are not fragmented and indexes are in separate dbspace. > I will: > 1. change LRU_MAX_DIRTY=80, LRU_MIN_DIRTY=40,LTAPEDEV=/dev/null > 2. create database without logging > 3. create tables without indexes and constraints > 4. load data > 5. recreate indexes & constraints > 6. change database to logging > 7. change Informix parameters back to "normal" values > > Is there any other informix parameters that I have to change > during dbimport if > I want to speed it up? > > It is 2 CPU system with informix 7.20. > > > Thanks >