topic Re: Internet bandwidth allocation for QV Extracts in QlikView

Internet bandwidth allocation for QV Extracts

Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

I want to understand that on what basis the internet bandwidth is assigned for QV extracts? I have scenario where I am fetching the data from Sql server 2012 and this sql server is out side of local network. around 100 million rows I am goin to fetch from database. In this scenario what will be the ideal internet bandwidth should assign.

Re: Internet bandwidth allocation for QV Extracts

Thu, 27 Aug 2015 12:23:15 GMT

gwassenaar‌ swuehl‌

Re: Internet bandwidth allocation for QV Extracts

jonathandienst — Thu, 27 Aug 2015 12:28:50 GMT

Its impossible to answer that question as it is totally dependant on a host of factors outside of Qlikview.

Re: Internet bandwidth allocation for QV Extracts

Colin-Albert — Thu, 27 Aug 2015 12:34:31 GMT

Do you need to load 100M rows every time?

I would suggest you search for Incremental Load to find out how to make the load more efficient.

Also only load the fields you require, to reduce the width of each row. Do not use Select * From...

If the server is remote, then it may be worth considering using a stored procedure or view on the SQL side, if that helps reduce the amount of data being passed to QlikView.

These posts by Marcus_Sommer should help

basics of data modelling

advanced topics of qlik datamodels

Re: Internet bandwidth allocation for QV Extracts

Peter_Cammaert — Fri, 28 Aug 2015 07:28:28 GMT

Put a Publisher in the same LAN as your SQL database and let it do the reloads. You may have to define different data stages to handle the incremental load (always a good thing to do) efficiently. Publish the resulting end-user QVW on one or more QVS close to your users. You will only transfer data that has been processed and compressed into a QVW over the internet.

Peter