Re: Export/Import Database - Help??

Posted in 1994

Richard Spitz — 31 Oct 1994 08:33:06 GMT — source: Informix-list mailing list archive (1991-1998)

Bill Ennis (ennis@ssd.comm.mot.com) wrote: : Warning: If you are using Online you will lose the dbspace/extent : information ;( However, it does fit all tables into one extent ;)). How can Online fit all tables into one extent? AFAIK, dbimport uses the default extent size of 16k, so large tables will get split into many little pieces, and performance will degrade serious- ly if the number of extents exceeds 8 for a table. Could one of the gurus please shed some light on this? Regards, Richard -- +----------------------------+-------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3421 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | | +----------------------------+-------------------------------------------+