Forum / Remote Desktop Manager - Feature Request

Better tree refresh method

  • Create an Issue
  • Cancel

Hi Guys,

I'm suffering with performance issues with RDM.
13.5.9.0 and 13.5.6.0 (not tested earlier versions)

When I'm working in the connection overview, every step is taking long time.
Duplication of an entry, creating a new entry and so on.

I'm currently running the debugging window.
And I'm seeing, that every change I do, modify copy create delete an entry, reloads the whole tree with all connection objects.
At the moment we don't have many connections (Around 1600)
But maybe you can implement a faster incremental way to update the tree, not to load the whole tree at a change.

Thank you

Best Regards
Jonas

Clock6 mths

Under normal circumstances loading the tree view should take about 100ms for 1600 sessions

Example, 850 sessions:

TreeView.LoadConnectionList...
GetGroupInfos : 0 ms
BeginUpdate...
ApplyGroupCustomImages : 0 ms
LoadConnectionInTreeNode : 44 ms
PreCreateGroups : 10 ms - Count : 1
BeginUpdate : 61 ms
TreeView.LoadConnectionList : 61 ms

Can you send us your profiler logs for analysis? Put the text within [code] & [/code] tags to keep the indentation of the text. Also, with the Profiler window active make sure your "Profiler level = 1" & "Debug level = 0 or 1" unless instructed other wise. The profiler can have a major impact on loading the tree view. For example having "Load Connections Detail" checked:

TreeView.LoadConnectionList...
GetGroupInfos : 0 ms
BeginUpdate...
ApplyGroupCustomImages : 0 ms
LoadConnectionInTreeNode : 7300 ms
PreCreateGroups : 7 ms - Count : 1
BeginUpdate : 7314 ms
TreeView.LoadConnectionList : 7319 ms

Stefane Lavergne

signaturesignature

Clock6 mths

Hi Stefane,

thanks for your reply smile

Creating an rdp entry

Thread : 127
----------------------------------------
127 - Connection States: Refresh...
127 - CreateConnectionStateDictionary : 0 ms
127 - Connection States: Refresh : 0 ms

Thread : 83
----------------------------------------
83 - Connection States: Refresh...
83 - CreateConnectionStateDictionary : 0 ms
83 - Connection States: Refresh : 0 ms

Main thread (UI)
----------------------------------------
LoadConnectionList : 0 ms
Database.SaveConnection : 11 ms
reload: False hasSecurityChanged: False hasChanged: True
LoadConnections [MariaDB : DB - User] - 64-bit...
HasOfflineChanges...
HasOfflineSessionChanges : 84 ms
HasOfflineChanges : 84 ms
OfflineManager.GetDataSourceSettings : 0 ms
LoadConnectionsFromDataSource...
LoadDataSourceSettingsFromDataSource...
GetDataSourceSettings : 5 ms
LoadDataSourceSettingsFromDataSource : 5 ms
GetConnections...
Database.GetConnections...
Reading connections from database : 0 ms
DecryptData : 0 ms - Count : 1
DeserializeData : 0 ms - Count : 1
Database.GetConnections : 3 ms
GetConnections : 3 ms
DoMergeConnections...
PrepareConnectionList : 0 ms
Loop...
MigrateConnection : 0 ms
OfflineManager.Merge : 0 ms
MergeWithList - Contains : 0 ms
MergeWithList : 0 ms
Loop : 0 ms
Filter...
DecryptData : 0 ms
DeserializeData : 0 ms
Filter : 15 ms
DisposeAndClearConnections : 0 ms
VerifyMissingAddons : 0 ms
DoMergeConnections : 16 ms
LoadConnectionsFromDataSource : 66 ms
DecryptData : 0 ms
DeserializeData : 0 ms
DisposeAndClearConnections : 0 ms
LoadConnections [MariaDB : DB - User] - 64-bit : 202 ms
Connection States: Refresh...
CreateConnectionStateDictionary : 0 ms
Connection States: Refresh : 0 ms
TreeView.LoadConnectionList...
GetGroupInfos : 0 ms
BeginUpdate...
ApplyGroupCustomImages : 0 ms
LoadConnectionInTreeNode : 543 ms
PreCreateGroups : 46 ms - Count : 1
BeginUpdate : 594 ms
TreeView.LoadConnectionList : 594 ms
SelectionChanged : 59 ms

Thread : 4
----------------------------------------
4 - ThreadQueue.AddRow...
4 - Offline.AddOrUpdateConnection : 0 ms
4 - ThreadQueue.AddRow : 112 ms - Count : 1
4 - ThreadQueue.AddRow...
4 - Offline.AddOrUpdateConnection : 0 ms
4 - ThreadQueue.AddRow : 129 ms - Count : 1

Thread : 120
----------------------------------------
120 - OfflineManager.SaveMeta...
120 - <id removed>
120 - SaveSecurityInfo : 125 ms
120 - UpdateOffline : 1 ms
120 - PrivateConnectionManager.Saving : 1 ms
120 - ConnectionOverrideManager.Saving : 0 ms
120 - OfflineManager.SaveMeta : 130 ms

Thread : 82
----------------------------------------
82 - Connection States: Refresh...
82 - CreateConnectionStateDictionary : 0 ms
82 - Connection States: Refresh : 0 ms


Deleting an entry:

Main thread (UI)
----------------------------------------
reload: False hasSecurityChanged: False hasChanged: True
LoadConnections [MariaDB : DB - User] - 64-bit...
HasOfflineChanges...
HasOfflineSessionChanges : 0 ms
HasOfflineChanges : 0 ms
OfflineManager.GetDataSourceSettings : 0 ms
LoadConnectionsFromDataSource...
LoadDataSourceSettingsFromDataSource...
GetDataSourceSettings : 3 ms
LoadDataSourceSettingsFromDataSource : 3 ms
GetConnections...
Database.GetConnections...
Reading connections from database : 0 ms
DecryptData : 0 ms
DeserializeData : 0 ms
Database.GetConnections : 2 ms
GetConnections : 2 ms
DoMergeConnections...
PrepareConnectionList : 0 ms
Loop...
MigrateConnection : 0 ms
OfflineManager.Merge : 0 ms
MergeWithList - Contains : 0 ms
MergeWithList : 0 ms
Loop : 0 ms
Filter...
DecryptData : 0 ms
DeserializeData : 0 ms
Filter : 11 ms
DisposeAndClearConnections : 0 ms
VerifyMissingAddons : 0 ms
DoMergeConnections : 12 ms
LoadConnectionsFromDataSource : 60 ms
DecryptData : 0 ms
DeserializeData : 0 ms
DisposeAndClearConnections : 0 ms
LoadConnections [MariaDB : DB - User] - 64-bit : 103 ms
Connection States: Refresh...
CreateConnectionStateDictionary : 0 ms
Connection States: Refresh : 0 ms
TreeView.LoadConnectionList...
GetGroupInfos : 0 ms
BeginUpdate...
ApplyGroupCustomImages : 0 ms
LoadConnectionInTreeNode : 552 ms
PreCreateGroups : 46 ms - Count : 1
BeginUpdate : 603 ms
TreeView.LoadConnectionList : 603 ms
SelectionChanged...
LoadConnectionList : 7 ms
SelectionChanged : 157 ms

Thread : 84
----------------------------------------
84 - OfflineManager.SaveMeta...
84 - <id remove>
84 - SaveSecurityInfo : 128 ms
84 - UpdateOffline : 1 ms
84 - PrivateConnectionManager.Saving : 2 ms
84 - ConnectionOverrideManager.Saving : 125 ms
84 - OfflineManager.SaveMeta : 258 ms

Thread : 4
----------------------------------------
4 - ThreadQueue.AddRow...
4 - Offline.AddOrUpdateConnection : 0 ms
4 - ThreadQueue.AddRow : 258 ms


Best Regards
Jonas

Clock6 mths

What is your Profiler level & Debug level?

They should: Profiler level = 1 & Debug level = 0, if not could you try with the new values and see what you get?


600 ms for "TreeView.LoadConnectionList" is on high end for 1500'ish sessions

Stefane Lavergne

signaturesignature

Clock6 mths

Profiler = 1, Debug = 1 (as you told in the last post)
The new log with Profiler 1 Debug 0:

Creating a connection:


Main thread (UI)
----------------------------------------
09:01:23.092347 SelectionChanged...
09:01:23.137223 LoadConnectionList : 44 ms
09:01:23.191571 SelectionChanged : 98 ms
09:01:30.043317 LoadConnectionList : 3 ms
09:01:34.134393 Database.SaveConnection : 10 ms
09:01:34.164752 reload: False hasSecurityChanged: False hasChanged: True
09:01:34.164752 LoadConnections [MariaDB : -DB - User] - 64-bit...
09:01:34.164752 HasOfflineChanges...
09:01:34.242146 HasOfflineSessionChanges : 77 ms
09:01:34.242146 HasOfflineChanges : 77 ms
09:01:34.249017 OfflineManager.GetDataSourceSettings : 1 ms
09:01:34.249017 LoadConnectionsFromDataSource...
09:01:34.249017 LoadDataSourceSettingsFromDataSource...
09:01:34.252943 GetDataSourceSettings : 3 ms
09:01:34.252943 LoadDataSourceSettingsFromDataSource : 3 ms
09:01:34.288699 GetConnections...
09:01:34.291642 Database.GetConnections...
09:01:34.291642 Reading connections from database : 0 ms
09:01:34.292622 DecryptData : 0 ms - Count : 1
09:01:34.292622 DeserializeData : 0 ms - Count : 1
09:01:34.292622 Database.GetConnections : 3 ms
09:01:34.292622 GetConnections : 3 ms
09:01:34.292622 DoMergeConnections...
09:01:34.292622 PrepareConnectionList : 0 ms
09:01:34.292622 Loop...
09:01:34.293603 MigrateConnection : 0 ms
09:01:34.293603 OfflineManager.Merge : 0 ms
09:01:34.293603 MergeWithList - Contains : 0 ms
09:01:34.293603 MergeWithList : 0 ms
09:01:34.293603 Loop : 0 ms
09:01:34.296040 Filter...
09:01:34.296040 DecryptData : 0 ms
09:01:34.296040 DeserializeData : 0 ms
09:01:34.307953 Filter : 14 ms
09:01:34.308454 DisposeAndClearConnections : 0 ms
09:01:34.308956 VerifyMissingAddons : 0 ms
09:01:34.308956 DoMergeConnections : 15 ms
09:01:34.308956 LoadConnectionsFromDataSource : 59 ms
09:01:34.317477 DecryptData : 0 ms
09:01:34.317477 DeserializeData : 0 ms
09:01:34.338089 DisposeAndClearConnections : 0 ms
09:01:34.342014 LoadConnections [MariaDB : -DB - User] - 64-bit : 182 ms
09:01:35.236584 Connection States: Refresh...
09:01:35.236584 CreateConnectionStateDictionary : 0 ms
09:01:35.236584 Connection States: Refresh : 0 ms
09:01:35.238547 TreeView.LoadConnectionList...
09:01:35.238547 GetGroupInfos : 0 ms
09:01:35.238547 BeginUpdate...
09:01:35.809042 ApplyGroupCustomImages : 0 ms
09:01:35.809042 LoadConnectionInTreeNode : 519 ms
09:01:35.809042 PreCreateGroups : 46 ms - Count : 1
09:01:35.809042 BeginUpdate : 570 ms
09:01:35.809042 TreeView.LoadConnectionList : 570 ms
09:01:36.039553 SelectionChanged : 71 ms

Thread : 4
----------------------------------------
4 - 09:01:34.134393 ThreadQueue.AddRow...
4 - 09:01:34.134393 Offline.AddOrUpdateConnection : 0 ms
4 - 09:01:34.242146 ThreadQueue.AddRow : 108 ms - Count : 1
4 - 09:01:34.303942 ThreadQueue.AddRow...
4 - 09:01:34.303942 Offline.AddOrUpdateConnection : 0 ms
4 - 09:01:34.433134 ThreadQueue.AddRow : 129 ms - Count : 1

Thread : 15
----------------------------------------
15 - 09:01:34.308956 OfflineManager.SaveMeta...
15 - 09:01:34.308956 <cut>
15 - 09:01:34.433134 SaveSecurityInfo : 124 ms
15 - 09:01:34.435091 UpdateOffline : 1 ms
15 - 09:01:34.438035 PrivateConnectionManager.Saving : 2 ms
15 - 09:01:34.439017 ConnectionOverrideManager.Saving : 1 ms
15 - 09:01:34.439998 OfflineManager.SaveMeta : 130 ms


Deleting a connection:

Main thread (UI)
----------------------------------------
09:01:56.515709 reload: False hasSecurityChanged: False hasChanged: True
09:01:56.515709 LoadConnections [MariaDB : DB - User] - 64-bit...
09:01:56.515709 HasOfflineChanges...
09:01:56.515709 HasOfflineSessionChanges : 0 ms
09:01:56.516671 HasOfflineChanges : 0 ms
09:01:56.523541 OfflineManager.GetDataSourceSettings : 1 ms
09:01:56.523541 LoadConnectionsFromDataSource...
09:01:56.523541 LoadDataSourceSettingsFromDataSource...
09:01:56.527818 GetDataSourceSettings : 4 ms
09:01:56.527818 LoadDataSourceSettingsFromDataSource : 4 ms
09:01:56.563071 GetConnections...
09:01:56.567102 Database.GetConnections...
09:01:56.567102 Reading connections from database : 0 ms
09:01:56.567102 DecryptData : 0 ms
09:01:56.567102 DeserializeData : 0 ms
09:01:56.567102 Database.GetConnections : 3 ms
09:01:56.567102 GetConnections : 3 ms
09:01:56.567102 DoMergeConnections...
09:01:56.567102 PrepareConnectionList : 0 ms
09:01:56.567102 Loop...
09:01:56.567102 MigrateConnection : 0 ms
09:01:56.567102 OfflineManager.Merge : 0 ms
09:01:56.567102 MergeWithList - Contains : 0 ms
09:01:56.567102 MergeWithList : 0 ms
09:01:56.567102 Loop : 0 ms
09:01:56.569953 Filter...
09:01:56.569953 DecryptData : 0 ms
09:01:56.569953 DeserializeData : 0 ms
09:01:56.579427 Filter : 11 ms
09:01:56.579427 DisposeAndClearConnections : 0 ms
09:01:56.580946 VerifyMissingAddons : 1 ms
09:01:56.580946 DoMergeConnections : 13 ms
09:01:56.580946 LoadConnectionsFromDataSource : 57 ms
09:01:56.594321 DecryptData : 0 ms
09:01:56.594321 DeserializeData : 0 ms
09:01:56.608060 DisposeAndClearConnections : 0 ms
09:01:56.612966 LoadConnections [MariaDB : -DB - User] - 64-bit : 102 ms
09:01:57.535531 Connection States: Refresh...
09:01:57.535531 CreateConnectionStateDictionary : 0 ms
09:01:57.535531 Connection States: Refresh : 0 ms
09:01:57.536512 TreeView.LoadConnectionList...
09:01:57.536512 GetGroupInfos : 0 ms
09:01:57.536512 BeginUpdate...
09:01:58.110278 ApplyGroupCustomImages : 0 ms
09:01:58.110278 LoadConnectionInTreeNode : 510 ms
09:01:58.110278 PreCreateGroups : 58 ms - Count : 1
09:01:58.110278 BeginUpdate : 573 ms
09:01:58.110278 TreeView.LoadConnectionList : 573 ms
09:01:58.317257 SelectionChanged...
09:01:58.409552 LoadConnectionList : 91 ms
09:01:58.487110 SelectionChanged : 169 ms

Thread : 15
----------------------------------------
15 - 09:01:56.580946 OfflineManager.SaveMeta...
15 - 09:01:56.580946 <cut>
15 - 09:01:56.711931 SaveSecurityInfo : 131 ms
15 - 09:01:56.713895 UpdateOffline : 1 ms
15 - 09:01:56.715859 PrivateConnectionManager.Saving : 2 ms
15 - 09:01:56.841321 ConnectionOverrideManager.Saving : 124 ms
15 - 09:01:56.841321 OfflineManager.SaveMeta : 260 ms

Thread : 4
----------------------------------------
4 - 09:01:56.713895 ThreadQueue.AddRow...
4 - 09:01:56.713895 Offline.AddOrUpdateConnection : 0 ms
4 - 09:01:56.839359 ThreadQueue.AddRow : 262 ms

Best Regards
Jonas

Clock6 mths

How slow are these actions? 1s? 5s? 10s?

The profiler gives me 10ms-20ms for the save/delete + 102ms-203ms for the data refresh + 400ms-550ms for the tree fresh.

Your tree reload is slower than expected, my data source has 1800+ sessions and the tree reload takes about 164ms, so 1/3'ish of your reload. I'm trying to figure out why. We may need to add more profiler stop watches.

Stefane Lavergne

signaturesignature

Clock6 mths

Hi Stefane,

see attached gif, some time it takes around 2-5 seconds.
db add remove

Main thread (UI)
----------------------------------------
10:03:33.386033 LoadConnectionList : 6 ms
10:03:42.307228 Database.SaveConnection : 357 ms
10:03:42.363374 reload: False hasSecurityChanged: False hasChanged: True
10:03:42.363374 LoadConnections [MariaDB : DB - User] - 64-bit...
10:03:42.363374 HasOfflineChanges...
10:03:42.387438 HasOfflineSessionChanges : 24 ms
10:03:42.388443 HasOfflineChanges : 25 ms
10:03:42.403481 OfflineManager.GetDataSourceSettings : 1 ms
10:03:42.403481 LoadConnectionsFromDataSource...
10:03:42.403481 LoadDataSourceSettingsFromDataSource...
10:03:42.408995 GetDataSourceSettings : 5 ms
10:03:42.408995 LoadDataSourceSettingsFromDataSource : 5 ms
10:03:42.460133 GetConnections...
10:03:42.465661 Database.GetConnections...
10:03:42.466654 Reading connections from database : 0 ms
10:03:42.467152 DecryptData : 0 ms - Count : 1
10:03:42.467653 DeserializeData : 0 ms - Count : 1
10:03:42.467653 Database.GetConnections : 7 ms
10:03:42.467653 GetConnections : 7 ms
10:03:42.467653 DoMergeConnections...
10:03:42.468156 PrepareConnectionList : 0 ms
10:03:42.468156 Loop...
10:03:42.469160 MigrateConnection : 0 ms
10:03:42.469160 OfflineManager.Merge : 0 ms
10:03:42.469160 MergeWithList - Contains : 0 ms
10:03:42.469160 MergeWithList : 0 ms
10:03:42.469160 Loop : 1 ms
10:03:42.474171 Filter...
10:03:42.474171 DecryptData : 0 ms
10:03:42.474675 DeserializeData : 0 ms
10:03:42.524306 Filter : 55 ms
10:03:42.524306 DisposeAndClearConnections : 0 ms
10:03:42.525810 VerifyMissingAddons : 1 ms
10:03:42.525810 DoMergeConnections : 57 ms
10:03:42.525810 LoadConnectionsFromDataSource : 122 ms
10:03:42.542357 DecryptData : 0 ms
10:03:42.542357 DeserializeData : 0 ms
10:03:42.575454 DisposeAndClearConnections : 0 ms
10:03:42.602517 LoadConnections [MariaDB : DB - User] - 64-bit : 246 ms
10:03:45.122302 Connection States: Refresh...
10:03:45.122302 CreateConnectionStateDictionary : 0 ms
10:03:45.122803 Connection States: Refresh : 0 ms
10:03:45.124307 TreeView.LoadConnectionList...
10:03:45.124307 GetGroupInfos : 0 ms
10:03:45.124307 BeginUpdate...
10:03:46.668703 ApplyGroupCustomImages : 0 ms
10:03:46.668703 LoadConnectionInTreeNode : 1448 ms
10:03:46.668703 PreCreateGroups : 74 ms - Count : 1
10:03:46.668703 BeginUpdate : 1544 ms
10:03:46.668703 TreeView.LoadConnectionList : 1544 ms
10:03:47.238227 SelectionChanged : 138 ms
10:03:56.650352 reload: False hasSecurityChanged: False hasChanged: True
10:03:56.650352 LoadConnections [MariaDB : DB - User] - 64-bit...
10:03:56.651355 HasOfflineChanges...
10:03:56.651858 HasOfflineSessionChanges : 0 ms
10:03:56.652360 HasOfflineChanges : 1 ms
10:03:56.667898 OfflineManager.GetDataSourceSettings : 2 ms
10:03:56.667898 LoadConnectionsFromDataSource...
10:03:56.667898 LoadDataSourceSettingsFromDataSource...
10:03:56.676926 GetDataSourceSettings : 9 ms
10:03:56.676926 LoadDataSourceSettingsFromDataSource : 9 ms
10:03:56.735584 GetConnections...
10:03:56.738087 Database.GetConnections...
10:03:56.738087 Reading connections from database : 0 ms
10:03:56.738087 DecryptData : 0 ms
10:03:56.738087 DeserializeData : 0 ms
10:03:56.738087 Database.GetConnections : 2 ms
10:03:56.738588 GetConnections : 2 ms
10:03:56.738588 DoMergeConnections...
10:03:56.738588 PrepareConnectionList : 0 ms
10:03:56.738588 Loop...
10:03:56.738588 MigrateConnection : 0 ms
10:03:56.738588 OfflineManager.Merge : 0 ms
10:03:56.738588 MergeWithList - Contains : 0 ms
10:03:56.738588 MergeWithList : 0 ms
10:03:56.738588 Loop : 0 ms
10:03:56.740593 Filter...
10:03:56.741095 DecryptData : 0 ms
10:03:56.741095 DeserializeData : 0 ms
10:03:56.752124 Filter : 13 ms
10:03:56.752124 DisposeAndClearConnections : 0 ms
10:03:56.753128 VerifyMissingAddons : 1 ms
10:03:56.753128 DoMergeConnections : 14 ms
10:03:56.753128 LoadConnectionsFromDataSource : 85 ms
10:03:56.766664 DecryptData : 0 ms
10:03:56.766664 DeserializeData : 0 ms
10:03:56.788723 DisposeAndClearConnections : 0 ms
10:03:56.795746 LoadConnections [MariaDB : DB - User] - 64-bit : 150 ms
10:03:59.217370 Connection States: Refresh...
10:03:59.217370 CreateConnectionStateDictionary : 0 ms
10:03:59.217370 Connection States: Refresh : 0 ms
10:03:59.219380 TreeView.LoadConnectionList...
10:03:59.219380 GetGroupInfos : 0 ms
10:03:59.219380 BeginUpdate...
10:04:00.706885 ApplyGroupCustomImages : 0 ms
10:04:00.706885 LoadConnectionInTreeNode : 1360 ms
10:04:00.706885 PreCreateGroups : 114 ms - Count : 1
10:04:00.706885 BeginUpdate : 1487 ms
10:04:00.706885 TreeView.LoadConnectionList : 1487 ms
10:04:01.396239 SelectionChanged...
10:04:01.396239 LoadConnectionList : 0 ms
10:04:01.692034 SelectionChanged : 296 ms

Thread : 4
----------------------------------------
4 - 10:03:41.960287 ThreadQueue.AddRow...
4 - 10:03:41.960287 Offline.AddOrUpdateConnection : 0 ms
4 - 10:03:42.386436 ThreadQueue.AddRow : 426 ms - Count : 1
4 - 10:03:42.480712 ThreadQueue.AddRow...
4 - 10:03:42.480712 Offline.AddOrUpdateConnection : 0 ms
4 - 10:03:42.988556 ThreadQueue.AddRow : 508 ms - Count : 1
4 - 10:03:57.166744 ThreadQueue.AddRow...
4 - 10:03:57.166744 Offline.AddOrUpdateConnection : 0 ms
4 - 10:03:57.590883 ThreadQueue.AddRow : 841 ms

Thread : 13
----------------------------------------
13 - 10:03:42.526312 OfflineManager.SaveMeta...
13 - 10:03:42.526312 <removed>
13 - 10:03:42.988055 SaveSecurityInfo : 462 ms
13 - 10:03:42.991064 UpdateOffline : 2 ms
13 - 10:03:42.997080 PrivateConnectionManager.Saving : 5 ms
13 - 10:03:42.999084 ConnectionOverrideManager.Saving : 1 ms
13 - 10:03:42.999596 OfflineManager.SaveMeta : 473 ms

Thread : 18
----------------------------------------
18 - 10:03:54.380165 Connection States: Refresh...
18 - 10:03:54.380165 CreateConnectionStateDictionary : 0 ms
18 - 10:03:54.380165 Connection States: Refresh : 0 ms
18 - 10:03:56.753629 OfflineManager.SaveMeta...
18 - 10:03:56.753629 <removed>
18 - 10:03:57.163733 SaveSecurityInfo : 410 ms
18 - 10:03:57.165738 UpdateOffline : 2 ms
18 - 10:03:57.168754 PrivateConnectionManager.Saving : 2 ms
18 - 10:03:57.593893 ConnectionOverrideManager.Saving : 425 ms
18 - 10:03:57.593893 OfflineManager.SaveMeta : 840 ms


we can do a live-session if you want to, then you can have a look.

Thanks

Best Regards
Jonas

db_add_remove.gif
Clock6 mths

Are you by any chance running on a VM/Terminal Services? The UI elements that make up the edit screen are cached and should open faster the second time around. I'm assuming that prior to the video recording you had already done the exact same steps.

We will schedule a live-session with the support team (they will contact you) but, in the meantime, could you set your Profiler Level = 65 and create/edit a session and post the profiler trace?

Best regards,

Stefane Lavergne

signaturesignature

Clock6 mths

Hi Stefane,

I'm using a computer with windows 10.
Lokal installation of RDM, database is a mariadb-server running on ubuntu in a virtual machine on vmware esx.

Trace:


Main thread (UI)
----------------------------------------
15:43:04.418792 FrmConnection.DoInitializeComponent : 558 ms
15:43:04.520068 FrmConnection.LoadConnectionInControls...
15:43:04.522079 FrmConnection.RegisterDescriptors : 2 ms
15:43:04.779779 FrmConnection.LoadGroups : 257 ms
15:43:04.782787 FrmConnection.freConnectionMorePanel : 3 ms
15:43:04.811869 FrmConnection.freConnectionVPNPanel : 28 ms
15:43:04.811869 FrmConnection.freConnectionAdvancedPanel : 0 ms
15:43:04.811869 FrmConnection.freConnectionUIPanel : 0 ms
15:43:04.812874 FrmConnection.FreConnectionSecurityPanel : 0 ms
15:43:05.012421 FrmConnection.CreateConnectionSettingsFrame : 200 ms
15:43:05.035479 FrmConnection.LoadCredentialSessions : 22 ms
15:43:05.035479 FrmConnection.LoadCredentialSessions : 0 ms
15:43:05.035479 FrmConnection.LoadCredentialsToControls : 0 ms
15:43:05.087633 FrmConnection.Panels.LoadConnectionInControls...
15:43:05.087633 LoadConnectionList : 0 ms
15:43:05.106673 FrmConnection.Panels.LoadConnectionInControls : 66 ms
15:43:05.106673 FrmConnection.LoadConnectionInControls : 586 ms
15:43:15.163133 Database.SaveConnection : 15 ms
15:43:15.198231 reload: False hasSecurityChanged: False hasChanged: True
15:43:15.198231 LoadConnections [MariaDB : DB - User] - 64-bit...
15:43:15.198231 HasOfflineChanges...
15:43:15.280454 HasOfflineSessionChanges : 82 ms
15:43:15.281460 HasOfflineChanges : 82 ms
15:43:15.287477 OfflineManager.GetDataSourceSettings : 0 ms
15:43:15.287477 LoadConnectionsFromDataSource...
15:43:15.287477 LoadDataSourceSettingsFromDataSource...
15:43:15.292495 GetDataSourceSettings : 4 ms
15:43:15.292495 LoadDataSourceSettingsFromDataSource : 4 ms
15:43:15.327682 GetConnections...
15:43:15.330597 Database.GetConnections...
15:43:15.330597 Reading connections from database : 0 ms
15:43:15.330597 DecryptData : 0 ms - Count : 1
15:43:15.331597 DeserializeData : 0 ms - Count : 1
15:43:15.331597 Database.GetConnections : 3 ms
15:43:15.331597 GetConnections : 3 ms
15:43:15.331597 DoMergeConnections...
15:43:15.331597 PrepareConnectionList : 0 ms
15:43:15.331597 Loop...
15:43:15.331597 MigrateConnection : 0 ms
15:43:15.331597 OfflineManager.Merge : 0 ms
15:43:15.331597 MergeWithList - Contains : 0 ms
15:43:15.331597 MergeWithList : 0 ms
15:43:15.331597 Loop : 0 ms
15:43:15.333600 Filter...
15:43:15.333600 DecryptData : 0 ms
15:43:15.333600 DeserializeData : 0 ms
15:43:15.345634 Filter : 13 ms
15:43:15.345634 DisposeAndClearConnections : 0 ms
15:43:15.345634 VerifyMissingAddons : 0 ms
15:43:15.345634 DoMergeConnections : 14 ms
15:43:15.345634 LoadConnectionsFromDataSource : 58 ms
15:43:15.353655 DecryptData : 0 ms
15:43:15.353655 DeserializeData : 0 ms
15:43:15.380728 DisposeAndClearConnections : 0 ms
15:43:15.386748 LoadConnections [MariaDB : DB - User] - 64-bit : 192 ms
15:43:16.240080 Connection States: Refresh...
15:43:16.240080 CreateConnectionStateDictionary : 0 ms
15:43:16.240080 Connection States: Refresh : 0 ms
15:43:16.241082 TreeView.LoadConnectionList...
15:43:16.241082 GetGroupInfos : 0 ms
15:43:16.241082 BeginUpdate...
15:43:16.813653 ApplyGroupCustomImages : 0 ms
15:43:16.813653 LoadConnectionInTreeNode : 519 ms
15:43:16.813653 PreCreateGroups : 47 ms - Count : 1
15:43:16.813653 BeginUpdate : 572 ms
15:43:16.813653 TreeView.LoadConnectionList : 572 ms
15:43:17.046328 SelectionChanged : 48 ms
15:43:22.355067 reload: False hasSecurityChanged: False hasChanged: True
15:43:22.355067 LoadConnections [MariaDB : DB - User] - 64-bit...
15:43:22.355067 HasOfflineChanges...
15:43:22.355067 HasOfflineSessionChanges : 0 ms
15:43:22.355067 HasOfflineChanges : 0 ms
15:43:22.362086 OfflineManager.GetDataSourceSettings : 0 ms
15:43:22.362086 LoadConnectionsFromDataSource...
15:43:22.362086 LoadDataSourceSettingsFromDataSource...
15:43:22.366096 GetDataSourceSettings : 4 ms
15:43:22.366096 LoadDataSourceSettingsFromDataSource : 4 ms
15:43:22.400267 GetConnections...
15:43:22.402212 Database.GetConnections...
15:43:22.402212 Reading connections from database : 0 ms
15:43:22.402212 DecryptData : 0 ms
15:43:22.402212 DeserializeData : 0 ms
15:43:22.402212 Database.GetConnections : 2 ms
15:43:22.402212 GetConnections : 2 ms
15:43:22.403198 DoMergeConnections...
15:43:22.403198 PrepareConnectionList : 0 ms
15:43:22.403198 Loop...
15:43:22.403198 MigrateConnection : 0 ms
15:43:22.403198 OfflineManager.Merge : 0 ms
15:43:22.403198 MergeWithList - Contains : 0 ms
15:43:22.403198 MergeWithList : 0 ms
15:43:22.403198 Loop : 0 ms
15:43:22.405205 Filter...
15:43:22.405205 DecryptData : 0 ms
15:43:22.405205 DeserializeData : 0 ms
15:43:22.413226 Filter : 10 ms
15:43:22.413226 DisposeAndClearConnections : 0 ms
15:43:22.414228 VerifyMissingAddons : 0 ms
15:43:22.414228 DoMergeConnections : 11 ms
15:43:22.414228 LoadConnectionsFromDataSource : 52 ms
15:43:22.425258 DecryptData : 0 ms
15:43:22.425258 DeserializeData : 0 ms
15:43:22.438293 DisposeAndClearConnections : 0 ms
15:43:22.443307 LoadConnections [MariaDB : DB - User] - 64-bit : 93 ms
15:43:23.312687 Connection States: Refresh...
15:43:23.312687 CreateConnectionStateDictionary : 0 ms
15:43:23.312687 Connection States: Refresh : 0 ms
15:43:23.313689 TreeView.LoadConnectionList...
15:43:23.313689 GetGroupInfos : 0 ms
15:43:23.313689 BeginUpdate...
15:43:23.889262 ApplyGroupCustomImages : 0 ms
15:43:23.889262 LoadConnectionInTreeNode : 519 ms
15:43:23.889262 PreCreateGroups : 51 ms - Count : 1
15:43:23.889262 BeginUpdate : 575 ms
15:43:23.889262 TreeView.LoadConnectionList : 575 ms
15:43:24.152801 SelectionChanged...
15:43:24.152801 LoadConnectionList : 0 ms
15:43:24.209957 SelectionChanged : 57 ms

Thread : 4
----------------------------------------
4 - 15:43:15.158123 ThreadQueue.AddRow...
4 - 15:43:15.158123 Offline.AddOrUpdateConnection : 0 ms
4 - 15:43:15.280454 ThreadQueue.AddRow : 123 ms - Count : 1
4 - 15:43:15.342625 ThreadQueue.AddRow...
4 - 15:43:15.342625 Offline.AddOrUpdateConnection : 0 ms
4 - 15:43:15.489024 ThreadQueue.AddRow : 146 ms - Count : 1
4 - 15:43:22.556617 ThreadQueue.AddRow...
4 - 15:43:22.557622 Offline.AddOrUpdateConnection : 0 ms
4 - 15:43:22.693993 ThreadQueue.AddRow : 279 ms

Thread : 62
----------------------------------------
62 - 15:43:15.346635 OfflineManager.SaveMeta...
62 - 15:43:15.346635 b795e7e0-90e2-4b55-b6e9-95bf39ef8d29
62 - 15:43:15.490028 SaveSecurityInfo : 143 ms
62 - 15:43:15.492034 UpdateOffline : 1 ms
62 - 15:43:15.494051 PrivateConnectionManager.Saving : 1 ms
62 - 15:43:15.495042 ConnectionOverrideManager.Saving : 1 ms
62 - 15:43:15.495042 OfflineManager.SaveMeta : 149 ms

Thread : 46
----------------------------------------
46 - 15:43:22.414228 OfflineManager.SaveMeta...
46 - 15:43:22.414228 b795e7e0-90e2-4b55-b6e9-95bf39ef8d29
46 - 15:43:22.554613 SaveSecurityInfo : 140 ms
46 - 15:43:22.556617 UpdateOffline : 1 ms
46 - 15:43:22.559625 PrivateConnectionManager.Saving : 2 ms
46 - 15:43:22.694996 ConnectionOverrideManager.Saving : 135 ms
46 - 15:43:22.694996 OfflineManager.SaveMeta : 280 ms

Best Regards
Jonas

Clock6 mths

Hi Jonas,

As discussed with Stefane, I just sent you a link to book a remote session in email.

Best regards,



David Grandolfo

signaturesignature

Clock6 mths