topic Re: QlikView Server refresh time in QlikView

QlikView Server refresh time

sifatnabil — Thu, 10 Dec 2015 08:34:56 GMT

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.

Re: QlikView Server refresh time

Anonymous — Thu, 10 Dec 2015 08:42:10 GMT

Do you want to refresh after each and every 15 sec, is it?

Re: QlikView Server refresh time

sifatnabil — Thu, 10 Dec 2015 08:43:10 GMT

That's correct. So the end user can keep seeing live data every 15 or 10 seconds.

Re: QlikView Server refresh time

Anonymous — Thu, 10 Dec 2015 08:49:02 GMT

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..

Re: QlikView Server refresh time

sifatnabil — Thu, 10 Dec 2015 08:50:22 GMT

Thanks - so there wouldn't be any performance issues? QMC allows 10 or 15 second refresh schedule?

Re: QlikView Server refresh time

tresB — Thu, 10 Dec 2015 08:53:12 GMT

You can try 'Continuously' reload option.

Re: QlikView Server refresh time

sifatnabil — Thu, 10 Dec 2015 08:55:49 GMT

I've read in the forum that continuous reload causes performance issues. The server accommodates some 50 other dashboards.

Re: QlikView Server refresh time

tresB — Thu, 10 Dec 2015 09:06:09 GMT

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.

Re: QlikView Server refresh time

cbb — Thu, 10 Dec 2015 09:16:34 GMT

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

Re: QlikView Server refresh time

jagan — Thu, 10 Dec 2015 09:17:02 GMT

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.

Re: QlikView Server refresh time

Anonymous — Thu, 10 Dec 2015 09:20:34 GMT

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.

Re: QlikView Server refresh time

Peter_Cammaert — Thu, 10 Dec 2015 09:41:57 GMT

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