Re: Load/Unload Nuances

U can Art Kagel's dbcopy utility to do the same ... it uses ARRAYs to INSERT data so its a much faster process than unload/load ... HTH Thanx much, Rajib Sarkar Advisory Support Engineer (RAS) IBM Data Management Group Ph : (602)-217-2100 Fax: (602)-217-2100 As long as you derive inner help and comfort from anything, keep it -- Mahatma Gandhi keepitliteus@yaho o.com (aspiring To: informix-list@iiug.org immigrant) cc: Sent by: Subject: Load/Unload Nuances owner-informix-li st@iiug.org 06/30/2003 09:22 AM Please respond to keepitliteus Hi Guru's, A question on unloading/loading data. I want to un,oad data from one Informix DB and load it onto another. If time is not a constraint to do this, is it necessary to drop the indices before loading the data ? 2. Is dbload a better way to load data as it also logs the details of rows loaded. 3.Also , is it a good idea to sort the data before loading the data ? My guess is there may be a difference in the indexing process, if data is already sorted. (Although we cannot ensure it always in the real world). Since we can sort data when we migrate, is it a good idea to sort and then load ? Thanks in Advance! and any other ideas are most welcome. Thanks sending to informix-list