IntelliJ SQL console slowness?

Answered
Avatar
Bruno Genovese
Created

I have a stored procedure that runs in 20-30 seconds in MSSMS or my EMS SQL Manager database tools, returning about 30,000 rows.   

But when using the IntelliJ SQL console to run the same stored procedure it is taking 10 times or longer (has not finished running yet).

Any idea why?   And is there any way to improve this, or is it an inherit problem with the JDBC drivers?

Votes

0

Share

1 comment
Avatar
Yaroslav Bedrov
Created

Hello Bruno,

There might be different factors. Please attach IDE logs after reproducing the issue for investigation from:

  1. Help -> Collect logs and diagnostic data
  2. Help -> Show SQL logs (database.log files)
0

Please sign in to leave a comment.