concurrent sqlload
From: Chuck Hamilton <chuckh_at_dvol.com>
Date: 1996/04/15
Message-ID: <3172534f.4792920_at_news2.ios.com>#1/1
Date: 1996/04/15
Message-ID: <3172534f.4792920_at_news2.ios.com>#1/1
I have a data warehouse that I update once a month by reloading all the tables with sqlload. There's approximately 80 tables in the DW ranging in size from a few rows to millions of rows. Currently we load the tables one at a time with a unix shell script. I'm thinking about loading them simultaneously by adding an & at the end of each sqlload command, and a wait command at the very end. Do you think this will decrease the total load time? Will it overwhelm the database? If it's too many tables to load at once, what would you suggest as a smaller number?
TIA
-- Chuck Hamilton chuckh_at_dvol.com Never share a foxhole with anyone braver than yourself!Received on Mon Apr 15 1996 - 00:00:00 CEST