Loading multiple tables from MySQL at the same time

[#1]

I have a loading script like the following:

LIB CONNECT TO 'DB1';

LOAD ... ;

SQL ...;

LIB CONNECT TO 'DB2';

LOAD ... ;

SQL ...;

LIB CONNECT TO 'DB3';

LOAD ... ;

SQL ...;

LIB CONNECT TO 'DB4';

LOAD ... ;

SQL ...;

Each SQL runs for 5 minutes; in total we need 20 minutes. Is there any way to make them run at the same time so that total time needed will be 5 minutes only?

[#2 · Accepted solution]

Hi Zikun,

If you are storing all tables in QVD's then the simplest thing you can do is write each table load script in a seperate QVW and run them in QMC at same time.

-Ashok.