SEO

#1 (**permalink**) 04-19-2008, 06:04 PM

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

#2 (**permalink**) 04-19-2008, 06:04 PM

On 30 Jun 2003 09:22:06 -0700, keepitliteus@yahoo.com (aspiring
immigrant) wrote:

See below . . .

>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 ?

No, it isn't, but it makes the load more efficient and it allows for a
'cleaner' index as well.

>2. Is dbload a better way to load data as it also logs the details of
>rows loaded.

dbload is OK as it gives you the ability to commit every 'n' rows.
>
>3.Also , is it a good idea to sort the data before loading the data ?

I never have worried about that . . . . . that's what Informix indices
are for . . . <G>

>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 ?

Don't know. Probably not much of a difference, as Informix will scan
each row anyway for the data needed to create the index.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Load/Unload Nuances