SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[9.2.346 Pro] - Object hints taking long time to popup
Goto page 1, 2  Next
 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[9.2.346 Pro] - Object hints taking long time to popup
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2100

Post [9.2.346 Pro] - Object hints taking long time to popup Reply with quote
Timed hints (when only hovering over the object) take large amount of time to pop up. Immediate hints (using Ctrl + hover) will take some time (sometimes seconds) if they pop up at all, predominantly there's only the windows Notification sound playing and no pop up or any kind of info/warning/error message is shown at all. This happens on both MySQL and SQL Server connections.
Sun Jul 16, 2017 11:11 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
To the best of my knowledge there are no functional changes in that function. I'm going to submit a ticket for investigation of side effects from other changes. Thank you very much for letting us know.about this issue.
Sun Jul 16, 2017 12:33 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2100

Post Reply with quote
That was quite disturbing. It did not pop up an exception dialog as had before, it put a notification onto the Action Center but without showing it actually. I had to click on the notification item to get the exception dialog. Put some contents into it and submitted the error report.
Sun Jul 16, 2017 2:05 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
I played for some time with both MySQL and SQL Server connections and on my test systems mouse-over hints appear within 1 to 2 seconds. However, when I open a fresh editor connected to a fairly large database with many tables and columns, it may take a while for the first hint to appear, sometimes as long as 10 seconds. I assume internally it loads the cache from the database data dictionary. But once the cache is loaded, it works very fast.

Could it be possible that something else is factoring in? Do you see your regular database queries running with typical speed or they seem to be slow too?
Mon Jul 17, 2017 10:00 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2100

Post Reply with quote
Other queries run fine. The initial delay is normal, I guess, but subsequent ones were lightning fast on 9.1. Now they definitely take longer. But what's really disturbing is that I was accustomed to getting the results for Ctrl+Hover almost instantly. Now I get an exception instead after a few seconds during which time SE seems to be frozen. It also interferes with Ctrl+clicking tables/views for a quick peek of their contents.

I restored factory default. It's still happening.

I've sent an error report with the following description:
Quote:

Ctrl + Hovering over a table on a MySQL Connection throws an exception.


It got issue tracking number 31746. Maybe it will prove useful.
Mon Jul 17, 2017 10:29 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
Thank you very much for the additional details. We will review that and follow up on that issue as quickly as possible.
Mon Jul 17, 2017 11:00 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2100

Post Reply with quote
This issue is extremely frustrating. Triggers every time I press Ctrl and the cursor is over something that could be queried for information, which happens to be most of the times, making copy-pasting a real pain in the back.
Thu Jul 20, 2017 12:56 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
I'm very sorry. I can actually reproduce that one on one of my systems. We are waiting for a fix for that bug.
Thu Jul 20, 2017 1:05 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 804
Country: United States

Post Reply with quote
Yeah there is something odd going on there, my ctrl+hover hints rarely if ever pop up.. it takes less time to just hover and get the popup now.
Thu Jul 20, 2017 4:04 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2100

Post Reply with quote
Do you get exceptions and temporary freezes as well?
Sat Jul 22, 2017 1:18 am View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 804
Country: United States

Post Reply with quote
gemisigo wrote:
Do you get exceptions and temporary freezes as well?


Temporary freezes with control held but no exceptions.
Sat Jul 22, 2017 7:34 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
Does this happen with SQL Server connections only?

Do you use custom version of "Object Info (MSSQL)" or an old version from 9.1?
Sun Jul 23, 2017 12:06 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2100

Post Reply with quote
It happens on both SQL Server and MySQL, with factory defaults restored.
Sun Jul 23, 2017 4:12 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
This issue has been fixed in the 9.2 release version. please upgrade to the latest version 9.2.348
Sun Jul 30, 2017 10:56 am View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 804
Country: United States

Post Reply with quote
Thank you.. that IS fixed now. ahhh.. glorious speed!
Mon Jul 31, 2017 11:25 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.