Where match or where?

[juanpcardenas201]

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?

[jonathandienst]

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.

[pradosh_thakur]

Below an option you can try

LOAD * inline [

account_count

5555.20];

Data:

LOAD *

FROM qvd

where exists (account_count );

[juanpcardenas201]

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

[juanpcardenas201]

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

[pradosh_thakur]

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.

[juanpcardenas201]

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

[pradosh_thakur]

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/311...

[jonathandienst]

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