- Would you like better web player load time?
- Would you like to be able to move more users to web player to get beyond slow DXP loads?
If the answer to any of these questions is yes, then this post is for you, as it focuses on improving web player load time using Scheduled Updates. This is the second part of a three part series on improving load times. Last week’s post discussed how to troubleshoot long load times in a DXP. Use the link below to check that out. To close out the series, I’ll discuss improving DXP load times using a combination of cached information links and scheduled updates.
What is a Scheduled Update?
(from TIBCO Spotfire Help)
In Spotfire Server, you can configure and run automated data updates to existing analyses. This saves web player load time for end users because they do not have to wait for the new data to download when they open the analysis. For analyses that contain links to large amounts of data, downloading fresh data can take a significant amount of time. Scheduled updates save time by downloading the latest data before users need it.
How Does it Work?
(from TIBCO Spotfire Help)
You can trigger updates in two ways:
- In Spotfire Server, administrators create rules specifying the analysis to pre-load, when to do it, whether the new data is automatically displayed to the end user, and so on.
- Using TIBCO Enterprise Message Service™ (EMS) or a web service, administrators can create “event-driven updates” that are triggered by an external process. (not the focus of this post)
When scheduling an update in Spotfire Server, you can configure the following options:
- The days of the week that the update runs.
- The times of day between which the updated analysis is available to end users.
- How often the server checks for new data.
- The resource pool on which to preload the analysis, and the number of Spotfire Web Player instances that should be available for users opening the analysis.
- Whether the updated data is automatically displayed in the user’s copy of the analysis, or the user decides when to refresh the information.
- Whether to allow cached and pre-computed data.
Requirements & PreRequisites
- Spotfire Server –> In order to run Scheduled Updates, you must select a DXP from the Spotfire Library, which means you need Spotfire Server. Thus, if you are using the desktop product, this will unfortunately not be of much help.
- Web Player –> Scheduled Updates are primarily for speeding up Web Player loading, and the DXP must load successfully on the Web Player to run a Scheduled Update. This post does not cover all of the details required for web player configuration. That is a HUGE topic in and of itself. Just know that if your DXP doesn’t load into web player, the Scheduled Update will not work.
- Don’t recommend Prompts on Information Links -> Scheduled Updates can work for DXPs with prompts, but (and this is a big BUT) it will open the DXP using the responses that were used when the DXP was last opened and saved. Thus, if you have a process for opening and saving, it could work. If you don’t, data loads could be messy and inconsistent. Unfortunately, this is a deal breaker for many DXPs, as prompts are very common, especially with large data sets.
Scheduled Updates are configured in the administration console, in the Scheduling & Routing section. Configuring Scheduled Updates is a two step process.
- Create the schedule (Use Create Schedule button)
- Create the rule (Use Create Rule button)
Create the Schedule
- Give the schedule a name. I like to indicate how often and/or when it runs.
- Specify which days of the week the job should run (only daily or weekly jobs are possible).
- Specify the hours the job should run (ex. between 6am and 6pm).
- Specify the time zone.
- Specify the reload interval (i.e. check for updates).
Create the Rule
- Specify the type of rule. In this case, the rule type is FILE.
- Give the rule a name. For example, “Early Morning 1hr Refresh” is a good name for something that kicks off early and refreshes every hour.
- Browse through the library to find the DXP.
- Select a resource pool and specify the number of instances. These settings will vary depending on how your web player is setup.
- Set a priority. For example, if you are running 10 scheduled updates, prioritize them 0-9 with 0 as the highest priority.
- Select which schedule should apply to the update. Note, even though I showed you how to create a rule first, you can also create schedules in this screen. I prefer to setup schedules in advance so I can see how a new schedule fits into what’s already being loaded.
When I configure Scheduled Updates, they are configured to start before folks get into the office (6am) so data is loaded and ready to go when people arrive. When users open a DXP on the Web Player that has a Scheduled Update behind it, that file will load much faster. Lastly, an Administrator can monitor the success (or failure) of Scheduled Updates in the Scheduling & Routing section of the Administration Console.
There you have it! In conclusion, scheduled updates will help dramatically improve web player load times. Stay tuned next week for a post on how to improve the load time of DXPs from the desktop.
Guest Spotfire blogger residing in Whitefish, MT. Working for SM Energy’s Advanced Analytics and Emerging Technology team!