Re: load from is slow
In SE environment , you can use dbload to do that. Offcourse there shouldn't
be indexes, and commit should be set to a high number (depending on memory,
cache).
--Vivek
----- Original Message -----
From: <Hannes.Visagie@za.didata.com>
To: <yosemite@accesscom.DELETEIT.com>; <informix-list@iiug.org>
Sent: Tuesday, September 05, 2000 12:13 AM
Subject: 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
>
>