Jump to content

Not able to see the Time taken to execute Each table/information link In Spotfire Analyst

Hema Vuppalapati

Recommended Posts

Hi Hema,

As described in the article, you can look into the sql.log file to check the execution time of the Information Link.

Excerpt from article:


You can even check the same in sql.log present on the TIBCO Spotfire Server (/tomcat/logs). Search on information link guid:

2020-05-22T15:55:05,031-0700 [*pool-13-thread-1, abc, #48, #79834*]: Executing Information Link 'Customer_IL' (bbd487d8-a07d-4d95-8e3c-97f9455584d1)

2020-05-22T15:55:24,359-0700 [*pool-13-thread-2, abc, #48, #79834*]: Information Link 'Customer_IL' (bbd487d8-a07d-4d95-8e3c-97f9455584d1) executed successfully, time: 18.909 seconds

2020-05-22T15:55:24,546-0700 [*Thread-41, abc, #48, #79834*]: Information Link 'Customer_IL' (bbd487d8-a07d-4d95-8e3c-97f9455584d1) job closed, time: 19.014 seconds

Information link "executed" timeis the time taken for execution on the database whereas "job closed" time is the total time taken to complete the job of bringing results back into the data table in the client.


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...