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.
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.