If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Speed up my Load processs

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-12-05, 13:41
lzt lzt is offline
Registered User
 
Join Date: Apr 2005
Posts: 8
Speed up my Load processs

What are the general things I should be looking to speed up my table load process?
Reply With Quote
  #2 (permalink)  
Old 10-12-05, 18:23
artemka artemka is offline
Registered User
 
Join Date: May 2004
Location: New York
Posts: 248
Load the table without the indexes and build them after the load

use High Performance Loader
Reply With Quote
  #3 (permalink)  
Old 10-12-05, 20:14
hoopsm hoopsm is offline
Registered User
 
Join Date: Oct 2005
Posts: 6
Yes, DROP/DISABLE INDEXES, CONSTRAINTS , TRIGGERS
also..

ALTER TABLE tableName TYPE(RAW) ;
LOAD DATA
ALTER TABLE tableName TYPE(STANDARD) ;

then
RE-ENABLE INDEX/CONSTRAINTS.
UPDATE STATISTICS

The High Performance Loader does all of the above for you in Express Mode, except maybee for Triggers and Statistics.
Reply With Quote
  #4 (permalink)  
Old 10-18-05, 15:22
lzt lzt is offline
Registered User
 
Join Date: Apr 2005
Posts: 8
Thanks for all your responses. I guess it's tine to read on HPL. I was just using basic load/unload. My load on tables with blob data is getting to be so ridiculous.
Reply With Quote
  #5 (permalink)  
Old 10-19-05, 09:35
lzt lzt is offline
Registered User
 
Join Date: Apr 2005
Posts: 8
It was not clear from the documentation if unloading data from one server and loading the data to another server is possible using onpladm. If so, can you please point me to the right direction(documentation). Thanks.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On