1 Reply Latest reply: Dec 7, 2016 12:54 AM by Ashok Vaddireddy RSS

    Loading multiple tables from MySQL at the same time

    Zikun Zhu

      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?