Re: Export/Import Database - Help??

Posted in 1994

Hugh Grierson — Thu, 3 Nov 94 00:53:36 GMT — source: Informix-list mailing list archive (1991-1998)

In article <392a42$jhv@arcadia.informatik.uni-muenchen.de> spitz@ana.med.uni-muenchen.de writes: >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. Online will coalesce adjacent extents, so unless you suffer a serious free space fragmentation problem each table will be loaded into one or a small number of extents. You still have to manually fix the next extent sizes though. -- Hugh Grierson hugh@fujitsu.co.nz 20C, hot & sunny