Hi
We are using TimesTen IMDB Version 11.2.2.18.5. For the past few months, we see a variance in the query execution time. If the same SQL is executed with same input data for 10 times, 8 times it executes within 2 milliseconds but 2 times it takes up to 5 milliseconds - 40 milliseconds. The application get a connection from the pool and executes a couple of sqls and stored procedures and close the connection. Either all the sqls in the the same connection are executed within the ideal time or all of them takes longer time to execute.
The execution time is captured from the application server , not from the TimesTen server. We are not sure if there is a network latency. Does TimesTen provide any kind of logs which give statistics on the query send by the application and the execution time. Any pointers to debug this issue is appreciated.
Thanks