Loading multiple tables from MySQL at the same time

Wed, 07 Dec 2016 05:42:28 GMT

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?

Re: Loading multiple tables from MySQL at the same time

Wed, 07 Dec 2016 05:54:46 GMT

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.

topic Loading multiple tables from MySQL at the same time in QlikView

Loading multiple tables from MySQL at the same time

Re: Loading multiple tables from MySQL at the same time