Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to optimize the Oracle table data in Qlikview script

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.

7 Replies
Anonymous
Not applicable
Author

Hi Community,

is any solution of above question?

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable
Author

Hi Anil,


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

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

Hi Community,

Any solution of this problem

how to optimize oracle query?

Anil_Babu_Samineni

Try delete all code and load only QVD

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

It's ODBC or OLE DB ?

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

Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!