Information Link based on Microsoft SQL Server loads very slowly in TIBCO Spotfire

Information Link based on Microsoft SQL Server loads very slowly in TIBCO Spotfire

Sometimes an information link query execution in TIBCO Spotfire may take considerably longer (as seen in execution time in the TIBCO Spotfire Server's sql.log) than when compared to any other JDBC tool with the exact same driver for Microsoft SQL server.

One of the reasons can be the "selectMethod" connection property setting in the data source template. The Microsoft SQL Server data source template by default will have selectMethod as "cursor" whereas most JDBC tools would have selectMethod as "direct".

  Try changing selectMethod=direct as follows in the Microsoft SQL Server data source template in the TIBCO Spotfire Server configuration (see Manual Configuration for more details) and save it.

<connection-property>
       <key>selectMethod</key>
       <value>direct</value>
</connection-property>

After making the change, restart the TIBCO Spotfire Server service and re-save any data sources using that data source template in the Information Designer for the template changes to take effect.

If there are still differences in the execution time when compared to 3rd party JDBC tools using the same driver, try changing the fetch-size to 0 in Data source of Information Designer.

If there are still issues, please contact TIBCO Spotfire at https://support.tibco.com/ for assistance. Doc: Manual configuration

• https://docs.tibco.com/pub/spotfire_server/10.3.4/doc/html/TIB_sfire_server_tsas_admin_help/GUID-C584A115-D1A5-4940-904F-C9A9E8F4F425.html

Doc: Data Source in Information Designer

• https://docs.tibco.com/pub/sfire-analyst/10.3.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/id/id_data_source_tab.htm

Doc: Data Source Template in configuration Tool

• https://docs.tibco.com/pub/spotfire_server/10.3.0/doc/html/TIB_sfire_server_tsas_admin_help/GUID-CC0AF293-611A-4D0E-A437-B52039A3BE44.html