time take to load from db

[#1]

hello guys ,

i just want to known if we r loading a 1 gb data from database how much time it will take for loading in to qlikview

how much time it will take that loaded data to convert in to a  qvd approximately 

thank you

[engishfaque]

Dear Naveen,

It depends on your system performance and data base system.

Normally it'll take few minutes.

Kind regards,

Ishfaque Ahmed

[gautik92]

depends on ur system configuration

[manojkulkarni]

Below are few stats on data load. Loading data directly from database depends on bandwidth of network.

Server Size

128 GB Ram

CPU 16 Cores

Rows: 107Million with 47 Columns

Time: 18 Mins

File Size is of 42 GB

Server Size

32 GB Ram

CPU 4 Cores

Rows: 17 Million with 47 Columns

Time: 44 Mins

QVD Load

----------------------------------------------

Server Size

128 GB Ram

CPU 16 Cores

Rows: 45 Million with 47 Columns

Time: 8 Mins

File Size is of 42 GB

Server Size

32 GB Ram

CPU 4 Cores

Rows: 17 Million with 47 Columns

Time: 7 Mins

​File Size is of 42 GB​