Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

rgvavihs
Valued Contributor

Load and sql select

     Hi all,

Can we write

Load * Where Condition ;

Sql select fields from tablename;

Will it increase the performance .i tried this but it is fectching records very slow

Thanks

6 Replies
Employee
Employee

Re: Load and sql select

Yes, you can, but this could perform better

Load * ;

Sql select fields from tablename Where Condition;

ravic906
Contributor III

Re: Load and sql select

Hi,

It's like loading all the data from SQL first and getting only what you require from preceding load. Why not apply the where condition on the SQL itself?

Not applicable

Re: Load and sql select

Better do optimized load, speed will increase.

MVP & Luminary
MVP & Luminary

Re: Load and sql select

Try adding the where condition to the sql statement. That way it won't load all the data from the source database, but only those matching the where clause.


talk is cheap, supply exceeds demand
rgvavihs
Valued Contributor

Re: Load and sql select

Hi All,

I have used where condition in sql statement too. Actually i used this statement its taking more time to load

Employee
Employee

Re: Load and sql select

using where at SQL clause is taking more time?

Are you familiar with Execution Plans? Could you post it here?