SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[12.2.387 Pro] - Object info in popup (MariaDB)

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[12.2.387 Pro] - Object info in popup (MariaDB)
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post [12.2.387 Pro] - Object info in popup (MariaDB) Reply with quote
When hovering the cursor over an object (eg. a table) in the editor, the popup window should show the comment on that object (if applicable). However, this does not happen until the object in the Database Explore is hovered over. As soon as you hover the cursor over the object in the Database Explorer, the comment that was missing from the popup appears, regardless of the location, it works in the editor after that. It also refreshes (in case it is cached) after eg. an ALTER TABLE t COMMENT 'whatever'; statement.

Check this short video here.
Wed Mar 29, 2023 9:35 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
I believe the root cause is that comments aren't yet in the cache, we are trying to delay some queries to shorten the loading times for intellisense items. While with MariaDB and Postgres reading system catalog views is quick, with some other databases like Oracle that's a very heavy lifting task.

One quick workaround for that, in the mouse over hint in the editor, click the Info link. It will show Info pane with object and column comments, and with some other stuff. and will also add it to the cache.
Wed Mar 29, 2023 10:38 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
Page 1 of 1

 
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.