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.
