SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[12.4.476 Pro] - Closing many result sets takes a long time

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[12.4.476 Pro] - Closing many result sets takes a long time
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2137

Post [12.4.476 Pro] - Closing many result sets takes a long time Reply with quote
When there are many result sets in the results tab closing them all at once takes a very long time and drastically increases with the number of result sets. I recall this to be fast in earlier versions.

Check out this short video here.
Mon Apr 08, 2024 5:37 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7903

Post Reply with quote
Is the timing related to the amount of data pulled into the tabs? Could you please check in the Task Manager how the CPU and memory look like when it takes long to close tabs? Is memory usage very high? Disk activity visible? (could be caused by virtual memory swapping)
Mon Apr 08, 2024 8:13 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2137

Post Reply with quote
I tried to record what happened. Check out this short video >>>here<<<.

I don't see anything that should cause this long "timeout". Though CPU usage goes up a bit, that's because of another process that starts using the CPU before even SE starts closing the result sets. Nothing indicates significant pressure on resources (CPU, RAM, IO, etc.). Regardless, SQL Editor goes into "Not responding status" about 5 seconds after clicking the Close All and does not regain consciousness until closing all the result sets.
Mon Jun 17, 2024 6:50 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7903

Post Reply with quote
Is it also taking long when you close the editor tab they are attached to?
Mon Jun 17, 2024 9:24 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2137

Post Reply with quote
Yes, I'd say it takes just as long to close the tab as it takes to close only the result sets.
Mon Jun 17, 2024 9:51 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7903

Post Reply with quote
Can you please try temporarily turning off The Document Manager option in Targets -> SQL Assistant Code Editor -> Document Manager -> Active. Does that make much of a difference on closing tabs?
If it does help, can you then try to reactivate it, but this time turn off Save Tools option only in the same section? Does that make any difference?
Thu Jun 20, 2024 11:41 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2137

Post Reply with quote
I've tried both the Document Manager inactive and it being active but with Save Tools set to off. The difference, if any, is negligible.
Fri Jun 21, 2024 2:59 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.