Spotfire Ideas Portal
Add a new idea Subscribe
Status Future Consideration
Product Spotfire
Categories System Administration
Created by Guest
Created on Oct 3, 2017

RELATED IDEAS

Limit the minimum number of connections to data sources

We have a large shared environment with something like 2,500 different Data Sources configured through Information Designer. We're finding that our servers take upwards of 20 minutes to start and believe the issue is that Spotfire Server is opening connections to all 2,500 data sources because they all have the default value of 1 for the minimum number of connections. Two requests:

  • Change the default for minimum number of connections to 0 - users should only require 1 minimum connection in unusual situations where performance of the first query to open the source is critical.
  • Allow for a system wide setting that says 'don't make connections to data sources until they are first used'. Many of our 2,500 data sources may not actually be in use (e.g. they are perhaps archived copies of development versions), but our server is opening them regardless.
  • Attach files
  • Guest
    Reply
    |     Dec 14, 2017

    Thanks - we haven't, but I think I will. That wouldn't contribute to slow starting on the servers because the setting affects what happens when users open analyses, but we have had issues in the past where the validation of on-demand links causes issues, so I think I'll disable it...

  • Guest
    Reply
    |     Dec 12, 2017

    Interesting. Have you turned on demand validation off?

    https://support.tibco.com/s/article/Tibco-KnowledgeArticle-Article-43714

  • Guest
    Reply
    |     Dec 11, 2017

    Thanks Christian - it's certainly a large environment :). After we researched this a little further we found that the server isn't actually making connections during server startup, but it is scanning through all the associated configuration and spending some time processing something - it's hard to tell what, but it takes it rather a long time! I have a ticket open with support trying to diagnose why our servers take so long to start and had hoped to delete this idea once I realised that it wasn't making connections - but there isn't a delete button for ideas...

  • Guest
    Reply
    |     Dec 4, 2017

    Have you tried setting the data source pooling scheme to DYNAMIC?

     

    https://docs.tibco.com/pub/spotfire_server/7.6.1/doc/html/tsas_admin_help/GUID-79436D7D-B7DE-41B9-8B70-69DBCDBE0EE0.html

     

    PS: 2,500 data sources, my god! We have a large shared environment too and only use 62 data sources. 

This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out. Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved. Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement. Terms of Use | Privacy Policy | Trademarks | Patents | Contact Us