Hi,
I have some big tables with over 1M records and some with 15M with some
indexes.
I would like to know if it is really faster to use HPF instead of
load/unload, I saw in informix guide that it's a lot of configuration to use
HPF, but if it's worth it!
Actually, I am not the DBA, but want to know because the DBA is not
interested in using HPF but I really need a faster way to load the data. By
the way, if you can tell me the difference in speed between the "deluxe" and
"express" mode. I am more intersted in the "deluxe" mode because I saw in
the manual that we must take a level 0 to reset a readonly flag. Most of
the time (not to say all) we need to load the data when the system is online
because 24x7.
The other point of interest, what about the checkpoint time during the load
with HPF ???
Actually we have dynamic server 7.3 and no logging, dirty read.
Thanks for your help!!!
please reply + cc:donald.leclerc@domtar.com
Donald Leclerc
dl@novertech.com
donald.leclerc@domtar.com