Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Parallel Load

Hi Qlikers:

I need to reload a humongous table 20 million record and 102 fields.

I positively know that there is a parameter called Enable Parallel Load, that shares the task among processors.

Does anybody know how to set that for SAP? Where is set?

The next is an example for Oracle. 4 is the number of processors you want to use. This one reduces time to half.

Select   /*+ PARALLEL(tabla1 , 4) PARALLEL(tabla2 , 4)  */ 

    Sum(tabla1.importe)

from tabla1, tabla2, tabla3

where tabla1.codigo = tabla2.codigo

and tabla2.codigo = tabla3.codigo

SQL does it automatically.

Thank you.

Tags (2)