Hi i m fetching two tables from the oracle server and making joins with these two tables which consists of million of records, but i want to reduce the running time, since it taking 3 hrs to load. pls let me know how i can reduce the time to below half hour.
The load time of the tables can be very dependent on the specs of your PC, however,
there are a few ways to reduce the load time of the tables, which you can control.
1. Make the tables QVDs in a separate application, then load and link them together in the application you want to show
2. Filter the data you are loading in the script by using a where statement. For instance, load the past month, quarter, or year instead of the entire table
First read no other go you have to pay the price.. After pulling it for the first time store in QVD, it will make your life easy for consecutive loads.
Think about implementing "Incremental load" so you need access the source only for delta.
ok i will store the millions of records in qvd and i will use the incrmental load .... but if 200 records added in oracle server and i will use the last date updated function in qlikview , so these will search millions of record and take the 200 records and add them in pervious qvd. so reading of millions of records also take more time..
