topic Re: Regarding DB issue in QlikView

Regarding DB issue

Thu, 05 Sep 2013 15:29:46 GMT

Hi All,

currently we are using ORACLE as our DB, i loaded data from DB using ODBC connection as follows

Load

Pnum,

pname,

location,

resource

SQL SELECT * from Tab1;

My problem is my Qlikview taking almsot 1 Hour to load 10000 records(I have licence for QV)

I don't Know why it is happening. is there any problem with " SQL SELECT * " ?

i'm new to QLIKVIEW, Please give me suggestion on this issue.

i'm waiting fast response from you.

Thanks,

Vamsi.

Re: Regarding DB issue

swuehl — Thu, 05 Sep 2013 15:34:09 GMT

Have you tried to SELECT only the fields you are actually using? So that the load on your DB / network is probably minimized?

Re: Regarding DB issue

Thu, 05 Sep 2013 16:45:17 GMT

Hi Swuehi,

Thanks for reply, you mean i have to load as follows?

SELECT

Pnum,

pname,

location,

resource

from tab1;

if it is correct, we are unable to use QLIKVIEW Functions right?

if we use " SQL SELECT * ", is it all the data from Table?

Give me suggestion pls

Thanks,

Chiru

Re: Regarding DB issue

Anonymous — Thu, 05 Sep 2013 16:48:25 GMT

No, he means this:

Load

Pnum,

pname,

location,

resource

;

SQL

SELECT

Pnum,

pname,

location,

resource

from tab1;

all functions can be used in the "Load" part.

Regards,

Michael