RE: load from is slow

Use High Performance Loader. I dont think it comes with SE, but only with ONLINE. We load 10Mil records + rebuild of indexes in +- 15 minutes on a SUN SPARC 450. -----Original Message----- From: yosemite@accesscom.DELETEIT.com [mailto:yosemite@accesscom.DELETEIT.com] Sent: Tuesday, September 05, 2000 5:41 AM To: informix-list@iiug.org Subject: Re: load from is slow On Mon, 4 Sep 2000 10:27:24 -0700, "r_hao" <r_hao@hotmail.com> wrote: >I have Informix SE 7.2 running on HP-UNIX 10.2. I used 'unload' to move a >table (16 million records in it) from another database into this new >database. However, 'load' is very slow. It only loads about 1 million >records in 5 hours. So the question is what is the best way to move data >from one database to another. For a large, bulk load, drop any existing indexes (except any UNIQUE indexes that you need to remian enforced, perhaps), then rebuild the indexes after loading is complete -- it saves the overhead of maintaining the indexes on the fly. -- Alan Denney yosemite at accesscom.com "My childhood was typical... when I was insolent, I was placed in a burlap bag and beaten with reeds. Pretty standard, really." -- Dr. Evil