Speeding up DBIMPORT

Posted in 2000

remove (_at_) to reply — Mon, 28 Aug 2000 14:40:55 +0200 — source: Informix-list mailing list archive (1991-1998)

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