How lang will take Qlikview to load 100000 records data into QVD?

[nihhalmca]

Hi All,

Any calculation is there for loading data into qvd form database, for instance 1000 records = 1 min, and 10000 records = 5 min like.....

Any different loading time for different data sources like oracle, sql server, ms access and excel....

could you please help me on it

Thanks in Advance,

Nihhal.

[Gysbert_Wassenaar · Accepted solution]

That's impossible to answer. It depends on too many things. How large are the records? How fast is the system QV runs on? How fast is the network? How fast is the database server? How costly is the sql statement the dbms has to execute to return the records? How much processing is done on the records in QV before storing them in a qvd file? etc... etc... etc...