Regarding DB issue

[#1]

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.

[swuehl]

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

[#3]

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

[Anonymous]

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