[rdnorth]

thanks.  that did help somewhat but it is still very slow.  I disabled UseDNS and GSSAPI on the SSH server, and the queries did speed up.

 

However – the UI is locking for at least 5 seconds on each query.  Time line is like this

Query in query editor:  press F8 to execute.

Query results appear in  result tab below [0.5seconds] – acceptable.

Then UI locks, the left panel with the list of tables seems to refresh/redraw / flash, and then I can finally get an edit box in the query results area.  This part is what is taking over 5 seconds.

 

Connecting to the same server with the same query/same server in verson 9 is instant.  Doing it in version 12 I get the 5+ second freeze.

Using F9 to simply execute the query read only there is never any delay. It is only for edit.

[rdnorth]

the problem only seems to be when executing queries for edit.  If I click on a table and go to table data, I can immediately start editing with no delay

[rdnorth]

I have the same problem as well with 12.3.3.

 

It is slow editing any query results, whether it is 1 result returned or many. takes close to 10 seconds from the time of F8 to when the UI is released to scroll in results window.

F9 execute only is fairly fast and no issue.

 

I’ve been using version 9.3 for a long time, and it works great for view and edit results sets.  I’ve been reluctant to upgrade to 12 since the few previous versions were slow. v 12.3.3 is just as bad.

 

1)  v 12.3.3  windows 7

2) specific server, ssh tunnel.  — I did note that on a direct remote connection it seemed fine. Will try a local server and a non ssh tunnel and report back.

3) connection via ssh tunnel to remote on a very fast 200Mbit internet connection. (no problem with this on version 9)

4) wait/idle time out are 28800

 

 thank you

 

[Author]

Posts