QlikView Server refresh time

[sifatnabil]

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.

[Anonymous]

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.

[Peter_Cammaert]

Nice trick. Keeps your Reload Engine allocated though...