Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how much time it takes a database table loaded into qlikview?

Hi,

    Anyone please tell me.

Regards,

devi.

6 Replies
Not applicable
Author

Its depending on data (records) of table. plz say approximately

Not applicable
Author

hi  g k,

         the table contains 2000 records.can you please tell me the details for time taking for table loaded into qlikview.

regards ,

devi

Not applicable
Author

Hi,

This would depend on the network speed / connector / driver used / etc...

In average (in my cases) when loading sql tables, it takes around 40 sec to 1 min to load a million records.

Once we tried on amazon server to load data from a db residing on local server, it took 30 minutes to load a million records.

So there are many hardware and architecture factors that can affect loading time.

senpradip007
Specialist III
Specialist III

It depends on couple of points.....

  • data size
  • if you are pulling data through any network, network traffic might be an issue.
  • transformation process
  • RAM size
sujeetsingh
Master III
Master III

Sen has given the right concept.

It depends on the environment and hardware that how much time it will take.

A part from this there are number of other set ups on data base too.

Not applicable
Author

3 min