topic Re: Load and sql select in QlikView

Load and sql select

Anonymous — Thu, 18 Jun 2015 12:03:10 GMT

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

Re: Load and sql select

Clever_Anjos — Thu, 18 Jun 2015 12:17:11 GMT

Yes, you can, but this could perform better

Load * ;

Sql select fields from tablename Where Condition;

Re: Load and sql select

Anonymous — Thu, 18 Jun 2015 12:21:49 GMT

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?

Re: Load and sql select

Thu, 18 Jun 2015 12:24:16 GMT

Better do optimized load, speed will increase.

Re: Load and sql select

Gysbert_Wassenaar — Thu, 18 Jun 2015 12:25:13 GMT

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.

Re: Load and sql select

Anonymous — Thu, 18 Jun 2015 12:56:32 GMT

Hi All,

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

Re: Load and sql select

Clever_Anjos — Thu, 18 Jun 2015 13:37:34 GMT

using where at SQL clause is taking more time?

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