topic Re: Where match or where? in App Development

Where match or where?

juanpablo_carde — Fri, 01 Feb 2019 04:27:22 GMT

Can someone tell me that it is more efficient and faster when loading data:

load * from qvd where account_count = '5555.20' or

load * from qvd where match (account_count, '5555.20').

Which is more efficient or better?

Re: Where match or where?

jonathandienst — Fri, 01 Feb 2019 04:35:45 GMT

If account_count is a numeric, then I would expect a numeric comparison to be faster as there is no need to convert to a number. Remove the quotes (where account_count = 5555.20). But whether there would be a meaningful difference - that would need to be tested.

Re: Where match or where?

pradosh_thakur — Fri, 01 Feb 2019 04:38:53 GMT

Below an option you can try

LOAD * inline [

account_count

5555.20];

Data:

LOAD *

FROM qvd

where exists (account_count );

Re: Where match or where?

juanpablo_carde — Fri, 01 Feb 2019 04:41:19 GMT

Thank you for your response.

And in the case that information is text, what is better , example:

where AREA='HEALTH' OR where match(AREA, 'HEALTH').

What is more efficent

Re: Where match or where?

juanpablo_carde — Fri, 01 Feb 2019 04:56:36 GMT

Thank you for your response.

And in the case that information is text, what is better , example:

where AREA='HEALTH' OR where match(AREA, 'HEALTH').

What is more efficent

Re: Where match or where?

pradosh_thakur — Fri, 01 Feb 2019 05:01:01 GMT

Why not try where exist ? It will make your load optimized too. About the performance @jonathandienst is much more qualified than me to comment on.

Re: Where match or where?

juanpablo_carde — Fri, 01 Feb 2019 05:15:25 GMT

Thank you for your response.
And in the case that information is text, what is better , example:
where AREA='HEALTH' OR
where match(AREA, 'HEALTH') or
where exists('HEALTH')

What is more efficent

Re: Where match or where?

pradosh_thakur — Fri, 01 Feb 2019 05:23:24 GMT

To my understanding Where exists(AREA).

Have a look at this old link
https://community.qlik.com/t5/QlikView-App-Development/optimize-and-non-optimze-load-in-qvd/td-p/311197

Re: Where match or where?

jonathandienst — Fri, 01 Feb 2019 05:34:57 GMT

Why don't you just test all three and see which performs better for your requirement?