Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a very small qvw that takes the last 15 seconds of data from an SQL server database, and running on a schedule on Windows Task Scheduler and stores it to a QVD. How feasible is it to have a QlikView Server refresh schedule of 10 or 15 seconds taking data from this QVD? It would only have this schedule for maybe 20 minutes in a whole day.
If you're catching my drift, I'm effectively trying to get as real time as possible without Direct Discovery with a tiny data set.
Do you want to refresh after each and every 15 sec, is it?
That's correct. So the end user can keep seeing live data every 15 or 10 seconds.
Okay, you can schedule your application in QMC as per your requirement...
But make sure, your Database Load and Application load time should not come in same window as it would lead you to wrong/some part of data..
Thanks - so there wouldn't be any performance issues? QMC allows 10 or 15 second refresh schedule?
You can try 'Continuously' reload option.
I've read in the forum that continuous reload causes performance issues. The server accommodates some 50 other dashboards.
That's true. But since, your reload is very light (just takes 10-15 secs), you probably can live with that. Just try and see how it goes.
depending on where you write the QVW file (locally or on network resource) you may also encounter some issues if the QVW file size grows and if it at some time takes more time to write it than the allotted run frequency (15 seconds) you would get fails.
/Chris
Hi,
If this is your requirement you have to do like this. Also, if the refresh dont took too long then it is ok. Monitor for few days
Regards,
Jagan.