

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
QlikView Server refresh time
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.
- « Previous Replies
-
- 1
- 2
- Next Replies »

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Do you want to refresh after each and every 15 sec, is it?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That's correct. So the end user can keep seeing live data every 15 or 10 seconds.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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..


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks - so there wouldn't be any performance issues? QMC allows 10 or 15 second refresh schedule?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can try 'Continuously' reload option.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I've read in the forum that continuous reload causes performance issues. The server accommodates some 50 other dashboards.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- « Previous Replies
-
- 1
- 2
- Next Replies »