Discussion Board for collaboration on QlikView Scripting.
And thanks for any answers or opinions in advance.
Our company has many sites across Australia and im told our implementation partner is looking to have overnight refreshing of QV data to keep the server overhead to a minimum.
This isnt ideal for some users, so has anyone heard of/tried/failed to use Database Replication and use the replication/s to handle constant refreshes?
Does anyone have any comments and suggestions?
Which overhead server are your implementation partner worried about? Database server or qv server?
If you are worried about qv server overhead may be you can use qv publisher to reload data from database and publish to qv server.
If you are worried about database server may be you can use delta load to to reduce the db server overhead.