Spotfire SQL Server Query Performance

I have been tuning our data warehouse database to improve performance of some Information Links. One particular fact table was taking over 5 minutes to load 90,000 rows of aggregated data. I applied a columnstore index to the fact table, and using SQL Server Management Studio (SSMS), the query now takes 2 seconds. Yet the Information Link still takes over 5 minutes to load the data into Spotfire.

The SQL queries are identical. Is this a SQL Server driver issue? The database is SQL Server 2014.

Any help, tips appreciated.

(1) Answer

Login