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.
You could put a Sleep(15000) to pause 15 seconds at the end of your reload qvw script so that despite reloading continuously there is a break of activity to alleviate the continuous load, and when you see how it is performing you could adjust the break time accordingly.
Nice trick. Keeps your Reload Engine allocated though...