How to improve performance connecting Spotfire Analyst using Data connection how much performance are expected to improve if we use precached Information Links

[Filippo Caminiti]

Hi,

a customer needs to manage some Spotfire Key Users with privilegies to create dashboards directly in production connecting to some preconfigured data connections which sometimes collect more than 10 M rows.

Issue: Key Users are (of course) not able to open this data connections because the size (in some case 10GB to 32GB!)

On the other hand, prod architecture has been sized to manage dashboards using Oracle Data Connectors leveraging caching on daily basis (2 WebPlayer nodes with 64 GB RAM). No problems on WebPlayer Side.

Options proposed have been:

- change the process and make sure developing occurs on in Test/DEv environment with a subset of data and then migrate to Prod -> not accepted by customer as they want to keep these Key USers as autonomous as possible

- Increase laptop RAM (mitigate but not solve the problem)

- using prefiltered Data connections, but also in this case replacing them with the un-filtered ones conduct to the same issue -> not accepted by customer

- Using Business Author -> Considered too much limited

Question: can we propose using pre-cached Information Links how much performance are expected to improve in this case (Spotfire Analyst connecting to Spotfire Server rather than using Data Connector ) does this solution solve S.Analyst experience but decrease Web-Player performance

What do you think

Thanks and Kind Regards,

Filippo

NOTE: using Windows Server 2012 R2 and Spotfire 7.5

[Varma Nadimpalli]

Hellofcaminit,

You may enable the following to improve data connection load times

 

 

 

 

Enable caching of data retrieved from the data connection