Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

Mapping LOAD with two fields, no processing - not optimized?

Hi,

I have been working on an app where several mapping LOADs used to take quite long. I changed the order of execution a bit and used a temporary table which is now loaded optimized, resulting in a mayor speedup for the whole thing.

The one that is taking the longest now is a mapping LOAD again with just two fields and no processing, coming from an "original" qvd (straight from SAP) via a relative path as is usual in our system. I wonder, why is this not optimized?

I will try, maybe with a PRECEDING LOAD or something.

Does anyone have any idea why this is so?

Thanks a lot!

Best regards,

DataNibbler

1 Reply
datanibbler
Champion
Champion
Author

Curious - with a small temp_table, loading the mapping_table resident from this, the temp_table is suddenly optimized, running much faster, and the mapping_table is faster, too (the mapping in total now takes 6sec, it used to be 32).

What is the reason for this? Is this generally so? Can I write that in my "best practices" catalog as something that should be done?