DataGrip (Idea DB plugin) extremely slow fetching

Asked May 23 '23 at 12:00

Active May 23 '23 at 12:00

Viewed 73 times

I am using IntelliJ Idea Database plugin (DataGrip) to query TimesTen database, but the fetching of the data takes extremely long.

-- 2023-05-23 13:39:09 [DB] [TimesTen] [console: console [TimesTen]] [session id: 1160215063] [statement id: 1756995763] finished - execution time: 1 s 746 ms, fetching time: 29 m 3 s 378 ms, total result sets count: 1

asked May 23 '23 at 12:00

Jakub Znamenáček

What JDBC driver do you use to get access to Oracle TimesTen? – Vasilii Chernov Jun 18 '23 at 22:08
Hi Vasilii, I am using C:\TimesTen\tt181_64\lib\ttjdbc11.jar, so it should be driver for TimesTen 18.1 and java 11. – Jakub Znamenáček Jun 22 '23 at 07:53
Just for completeness Oracle DB works perfectly fine in the same version of IntelliJ ```[2023-06-22 12:09:40] 1 row retrieved starting from 1 in 339 ms (execution: 139 ms, fetching: 200 ms)``` – Jakub Znamenáček Jun 22 '23 at 10:10
It could be that the issue in JDBC driver itself. Is there any way to contact their support or file an issue? – Vasilii Chernov Jul 28 '23 at 04:41
The same driver works completely fine in SQL Developer. – Jakub Znamenáček Jul 29 '23 at 08:50
So, if the driver works fine in IDEA it should work in DataGrip too. Could you share your IDEs versions and JBR versions? – Vasilii Chernov Aug 09 '23 at 16:32

DataGrip (Idea DB plugin) extremely slow fetching

0 Answers0