Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two huge sql tables with Table1 has 4213039 rows
and Table2 has 12710440 rows
when I am loading the tables into QVDs by using
Store Table1 into C:\qlikviewpath\Table1.qvd;
Store Table2 into C:\qlikviewpath\Table2.qvd;
to load the scrit execution is taking more than 14 minutes. could anyone let me know is there anyway to load data into QVD very fast.
Thanks.
Hello,
Probably you should optimize your query to last shorter. The row counts you mentioned are not really huge. If you have WHERE criteria in your query check if these columns have indexes.
Also if any part of your data will not be updated in the future, you could use Incremental Loading. Just store the whole table for once in a qvd file and then add the new parts to the old qvd file. This will significantly optimize your process.
Best.
Thanks. There is no indexes in the tables. and I have data migration so the table is updated. so, in this case how can I choose very fast load. could let me know please.
After writing the query run the estimated query plan -if you are using MS SQL. It will show you -if needed- a suggested index in a green line with the impact rate. You can right click to that suggestion to show missing index details and run the suggested index command.
How many megabytes thats qvds are using?
One Qvd is 1.52 GB and another Qvd is 546 MB
Hi Amelia,
Is it the loading of data from SQL to Qlikview that's taking a long time, or the writing of the data from Qlikview to QVD?
flipside
Hi,
Both are taking too long. Any help please.
thanks.
If else post your sample query, lets see to optimise!!!
I my humble opinion they´re are too big.
We have a 'golden rule' here that no qvd can be more than 100 Mb.
Is there any field that you can use to split your files? (Maybe a month)