Slow search

Hello,
Could you try to remove some search criteria in the filter context menu?

Regards

Did not help.

Also all the actions like adding an entry , edit one hangs a while before prompting...

Have you tried to enable the Profiler logs and verify if you see a bottleneck in the logs? It's in Help->Profiler

Regards

From the Profiler (level 3):


Thread : 17
----------------------------------------
17 - --> select ConnectionID, UserID, State, ExpirationDate, MachineName from ConnectionState : 23 ms

Thread : 16
----------------------------------------
16 - --> select ConnectionID, UserID, State, ExpirationDate, MachineName from ConnectionState : 4 ms

Main thread (UI)
----------------------------------------
TreeView.LoadConnectionList...
GetGroupInfos : 0 ms
BeginUpdate...
LoadConnectionList : 0 ms
LoadConnectionList : 9 ms
ApplyGroupCustomImages : 0 ms
LoadConnectionInTreeNode : 1645 ms
PreCreateGroups : 0 ms
BeginUpdate : 1741 ms
TreeView.LoadConnectionList : 1742 ms
SelectionChanged...
LoadConnectionList : 0 ms
LoadConnectionList : 0 ms
SelectionChanged : 40 ms
TreeView.LoadConnectionList...
GetGroupInfos : 0 ms
BeginUpdate...
LoadConnectionList : 0 ms
LoadConnectionList : 0 ms
ApplyGroupCustomImages : 0 ms
LoadConnectionInTreeNode : 1543 ms
PreCreateGroups : 0 ms
BeginUpdate : 1588 ms
TreeView.LoadConnectionList : 1588 ms
SelectionChanged...
LoadConnectionList : 0 ms
LoadConnectionList : 0 ms
SelectionChanged : 49 ms
TreeView.LoadConnectionList...
GetGroupInfos : 0 ms
BeginUpdate...
LoadConnectionList : 0 ms
LoadConnectionList : 0 ms
ApplyGroupCustomImages : 0 ms
LoadConnectionInTreeNode : 1620 ms
PreCreateGroups : 0 ms
BeginUpdate : 1658 ms
TreeView.LoadConnectionList : 1658 ms
SelectionChanged...
LoadConnectionList : 0 ms
LoadConnectionList : 0 ms
SelectionChanged : 37 ms


========================================================

And when I tried to edit an open entry (here the level was 1):


Main thread (UI)
----------------------------------------
reload: False hasSecurityChanged: False hasChanged: False
LoadConnections [Microsoft SQL Server : Prod SQL] - 64-bit...
DisposeAndClearConnections : 0 ms
LoadConnections [Microsoft SQL Server : Prod SQL] - 64-bit : 26 ms
reload: False hasSecurityChanged: False hasChanged: False
LoadConnections [Microsoft SQL Server : Prod SQL] - 64-bit...
DisposeAndClearConnections : 0 ms
LoadConnections [Microsoft SQL Server : Prod SQL] - 64-bit : 20 ms
SelectionChanged : 58 ms
reload: False hasSecurityChanged: False hasChanged: False
LoadConnections [Microsoft SQL Server : Prod SQL] - 64-bit...
DisposeAndClearConnections : 0 ms
LoadConnections [Microsoft SQL Server : Prod SQL] - 64-bit : 24 ms
FrmConnection.LoadConnectionInControls...
FrmConnection.RegisterDescriptors : 1 ms
FrmConnection.LoadGroups : 6 ms
FrmConnection.freConnectionMorePanel : 1 ms
FrmConnection.freConnectionVPNPanel : 13 ms
FrmConnection.freConnectionAdvancedPanel : 0 ms
FrmConnection.freConnectionUIPanel : 0 ms
FrmConnection.FreConnectionSecurityPanel : 0 ms
FrmConnection.CreateConnectionSettingsFrame : 132 ms
FrmConnection.LoadCredentialSessions : 41 ms
FrmConnection.LoadCredentialSessions : 0 ms
FrmConnection.LoadCredentialsToControls : 2 ms
FrmConnection.Panels.LoadConnectionInControls...
LoadConnectionList : 1 ms
FrmConnection.Panels.LoadConnectionInControls : 62 ms
FrmConnection.LoadConnectionInControls : 266 ms
Database.SaveConnection : 1779 ms
reload: False hasSecurityChanged: False hasChanged: True
LoadConnections [Microsoft SQL Server : Prod SQL] - 64-bit...
HasOfflineChanges...
HasOfflineSessionChanges : 0 ms
HasOfflineChanges : 0 ms
OfflineManager.GetDataSourceSettings : 0 ms
LoadConnectionsFromDataSource...
LoadDataSourceSettingsFromDataSource...
GetDataSourceSettings : 1 ms
LoadDataSourceSettingsFromDataSource : 1 ms
GetConnections...
Database.GetConnections...
Reading connections from database : 0 ms
DecryptData : 0 ms - Count : 1
DeserializeData : 0 ms - Count : 1
Database.GetConnections : 19 ms
GetConnections : 19 ms
DoMergeConnections...
PrepareConnectionList : 0 ms
DisposeAndClearConnections : 0 ms
DoMergeConnections : 1 ms
LoadConnectionsFromDataSource : 37 ms
DisposeAndClearConnections : 0 ms
LoadConnections [Microsoft SQL Server : Prod SQL] - 64-bit : 59 ms
TreeView.LoadConnectionList...
GetGroupInfos : 0 ms
BeginUpdate...
ApplyGroupCustomImages : 0 ms
LoadConnectionInTreeNode : 764 ms
PreCreateGroups : 98 ms - Count : 1
BeginUpdate : 865 ms
TreeView.LoadConnectionList : 865 ms
SelectionChanged : 15 ms

Thread : 7
----------------------------------------
7 - OfflineManager.SaveMeta...
7 - 64f7f33c-7b62-4d4a-9655-0ce73780242f
7 - SetSecurityInfo : 1 ms
7 - UpdateOffline : 0 ms
7 - PrivateConnectionManager.Saving : 0 ms
7 - ConnectionOverrideManager.Saving : 5 ms
7 - OfflineManager.SaveMeta : 7 ms

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




What can you say from that ?

Hi,
The Database.SaveConnection is very strange. Do you have a lot of logs in the database? Have you tried some log cleanup tool? Could you post the time when you filter?

Regards

This is search only:


Main thread (UI)
----------------------------------------
TreeView.LoadConnectionList...
GetGroupInfos : 0 ms
BeginUpdate...
ApplyGroupCustomImages : 0 ms
LoadConnectionInTreeNode : 1973 ms
PreCreateGroups : 0 ms
BeginUpdate : 1979 ms
TreeView.LoadConnectionList : 1979 ms
SelectionChanged : 36 ms




This is after logs cleanup...

How many result to do you get in the tree for this filter?

Regards

1... :(

Any news ? we are suffering here...

I still don't understand why it so slow even for a such small result. I've made some fixes and this should be in the next beta.

Regards

Hello,
We are facing exatly the same issue.
We also have a similar database size like the op, and also very slow search query.

We have version 13.6.6.0

Here is the profiler log:

Thank you

@IT Support,

Could you go in Help -> Diagnostic -> Data Source tab and post a screenshot of that window please.

Best regards,

Hello @Jeff

Here's the screenshot:


and also a copy/past of the entire text in the window:

Thank you

Hello,

Thank you for the information.

Quick question; are you using variables inside RDM? example $USERNAME$, $PASSWORD$


Best regards,

Hello,

No variables, no.

If you wish I can share my desktop with you in a remote session where you can have a look.

I updated to the latest and run after reindex, try it...

I checked for a newer version but I get the message


And what do you mean "after reindex"? can you be a bit more specific ?

Thank you

Under Administration -> Pack Data Source -> Index Maintenance...

No performance change after optimizing and reindexing.

@IT Support,

I don't know if this gonna help, but consider this as a long shot.

Could you go in the Administration tab and perform a cleanup of the database by executing the following;

Best regards,