Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Community,
is any solution of above question?
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
Hi Anil,
I am storing data into QVD that time it taking more time .
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
Hi Community,
Any solution of this problem
how to optimize oracle query?
Try delete all code and load only QVD
Hi,
It's ODBC or OLE DB ?
If it's OLE DB, you use Oracle Provider for OLE DB ?
Aurélien