Re: onunload vs. dbexport

Posted in 1996

Lester Knutsen — 13 Oct 1996 16:53:07 -0400 — source: Informix-list mailing list archive (1991-1998)

Neli, > > My new site is running its production instance on file system, and I'm > going to move it to raw disk. Everyone, Informix Tech. Support, you > forum contributors etc. says to use dbexport/dbimport. Why? What does > eveyonr have against the faster onunload/onload (we're talking OnLine > v7.13 here)? > > I'd be interested in any views. > Onload does outputs pages, so its faster, however it does not compress the pages and remove deleted rows as dbexport would do. Dbexport will only export rows. Dbimport will also rebuild all your indexes, onload will use the old indexes. I would use Onload if I did not need the database compressed or indexes rebuilt. Regards - Lester ############################################################################# # Lester Knutsen lester@access.digex.net # # Advanced DataTools Corporation Voice: 703-256-0267 # # Grant group privileges for Informix databases with DB Privileges # # Visit our Web page: http://www.access.digex.net/~lester # # Washington Area Informix User Group: http://www.access.digex.net/~waiug # #############################################################################