topic Re: How to optimize the Oracle table data in Qlikview script in QlikView

How to optimize the Oracle table data in Qlikview script

Anonymous — Thu, 09 Mar 2017 10:55:38 GMT

Hi Community,

I am fetching data of one table from Oracle to my Qlikview QVW.It taking 3 hrs to fetch data only for 2,00,000 lac. Also i have used filter.

is any solution to reduce this time upto 20 or 30 minutes.?

e.g.

Suppose i have test table in that table i have location wise data i have apply filter on location field and fetching data from Oracle to Qlikview script

Test

LOAD

Field 1,

Field 2,

Field 3,

Location;

SQL SELECT

Field 1,

Field 2,

Field 3,

Location

FROM Test where Location like 'Mumbai' ;

Same as above i fetching data of my table it taking more time to fetch from Oracle to Qlikview.

so how i optimize this script ?.

Thanks in advance.

Re: How to optimize the Oracle table data in Qlikview script

Anonymous — Thu, 09 Mar 2017 13:11:28 GMT

Hi Community,

is any solution of above question?

Re: How to optimize the Oracle table data in Qlikview script

Anil_Babu_Samineni — Thu, 09 Mar 2017 13:21:26 GMT

Can you try this for me

Test:

LOAD

Field 1,

Field 2,

Field 3,

Location;

SQL SELECT

Field 1,

Field 2,

Field 3,

Location

FROM Test where Location = 'Mumbai';

STORE Test into Text.qvd (qvd);

Then Drop Table

Drop Table Test;

Then load qvd to qlikview again

Load * from Test.qvd; // It should optimize and save some time to fetch data

Re: How to optimize the Oracle table data in Qlikview script

Anonymous — Thu, 09 Mar 2017 13:29:08 GMT

Hi Anil,

I am storing data into QVD that time it taking more time .

Re: How to optimize the Oracle table data in Qlikview script

Anonymous — Thu, 09 Mar 2017 13:38:09 GMT

I mean i have write syntax for saving data into QVD

e.g.

Test

LOAD

Field 1,

Field 2,

Field 3,

Location;

SQL SELECT

Field 1,

Field 2,

Field 3,

Location

FROM Test where Location like 'Mumbai' ;

store Test into Test.QVD;

Drop Table Test;

but before store data in QVD data fetching from Oracle to QVW taking more time

Re: How to optimize the Oracle table data in Qlikview script

Anonymous — Thu, 09 Mar 2017 13:53:11 GMT

Hi Community,

Any solution of this problem

how to optimize oracle query?

Re: How to optimize the Oracle table data in Qlikview script

Anil_Babu_Samineni — Thu, 09 Mar 2017 13:58:08 GMT

Try delete all code and load only QVD

Re: How to optimize the Oracle table data in Qlikview script

Aurelien_Martinez — Thu, 09 Mar 2017 14:42:44 GMT

Hi,

It's ODBC or OLE DB ?

If it's OLE DB, you use Oracle Provider for OLE DB ?

Aurélien