How to increase the speed

[#1]

Hi all,

I have several tables have same primary keys. Such as table one has Name Number, table two has Name Number date, Table Three has Name Date...Something just like that.

While I run more than 10 tables it seems that QV will combine different PK from tables. But it takes long time to run this step.

What should I add to the script in order to increase  speed to run the tables?

Thanks!!

[bbi_mba_76]

Hi,

I don't know your data model and I don't know how big are the tables, maybe you could concatenate them

[MK_QSL]

It's difficult to answer without knowing your data model but if there are synthetic keys, it will slow down your loading process.

[#4]

How to write the script for the synthetic keys?

[tomasz_tru]

Qlik will join the data using fields with the same name, so make sure it's not creating unecessary synthetic keys. You can use aliases to control what should be the key.