Skip to main content

Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-03-26 10:52 PM

Can I get Realtime? Using a slave replication to get as close to realtime as possible

Hi All,

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?

  • This would seperate infrastructure and keep the write databases as fast as possible
  • It would allow data feeds to wherever necessary and only files that need to be updated constantly can be.

Does anyone have any comments and suggestions?

Thanks

482 Views
0 Likes
1 Reply
Ferran_Garcia_Pagans
Former Employee
Former Employee
‎2012-03-27 04:54 AM

Hi Robin,

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.

F.

141 Views