Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Query

What is the best option for query between two:

1) To make query with joins at data base level and execute directly in QlikView..?

2) Select all data fields from data base and perform joins at QlikView level..?

Please discuss...

3 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Well it depends on what you are trying to do. If the result of the joined query is much smaller than the underlying tables, it may make sense to do the join in the server to reduce reload time and bandwidth.

However, if this join is complex or coming from large underlying tables, then this might place an unacceptable burden on the server, and if it is a busy transaction processing server, you may want to prioritize the server availability over reload performance.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
maksim_senin
Partner - Creator III
Partner - Creator III

Hi,

This is a design decision which depends on solving task.

Best regards,

Maxim

Anonymous
Not applicable
Author

Hi

It depends upon requirement and data