Performance with 1000 sessions
Hi,
I am currently testing RDM for my company
After I add 1200 sessions from securecrt to RDM (by import ) I see a lot of lags in the application.
from the performance profile I see that every time I am doing something that require loading the connection list it take ~500ms (it feel 2 seconds )
is there any thing you can do
please see the logs
Thanks
Nitzan
LoadConnections [mssql (Offline)]...
LoadConnections [mssql (Offline)] : 51 ms
===================== Go Online
GetOfflineEdits : 2 ms
LoadConnections [mssql]...
Connection cache up to date
LoadConnections [mssql] : 56 ms
===================== Edit Session
LoadConnections [mssql]...
Connection cache up to date
LoadConnections [mssql] : 51 ms
TreeView.LoadConnectionList...
GetGroupInfos : 0 ms
BeginUpdate...
ApplyGroupCustomImages : 0 ms
LoadConnectionInTreeNode : 350 ms
PreCreateGroups : 32 ms
BeginUpdate : 35 ms
TreeView.LoadConnectionList : 419 ms
Database.SaveConnection...
Database.SaveConnection : 16 ms
LoadConnections [mssql]...
OfflineManager.GetDataSourceSettings : 1 ms
LoadConnectionsFromDataSource...
LoadDataSourceSettingsFromDataSource...
GetDataSourceSettings : 0 ms
LoadDataSourceSettingsFromDataSource : 1 ms
OfflineManager.Save : 9 ms
GetConnections...
Database.GetConnections...
Reading connections from database : 0 ms
Decrypt (multi-threaded) : 0 ms
Deserialize (multi-threaded) : 0 ms
Process entries (overhead) : 1 ms
Database.GetConnections : 4 ms
GetConnections : 5 ms
PrepareConnectionList : 0 ms
OfflineManager.Save : 8 ms
DoMergeConnections : 35 ms
LoadConnectionsFromDataSource : 57 ms
LoadConnections [mssql] : 330 ms
TreeView.LoadConnectionList...
GetGroupInfos : 0 ms
BeginUpdate...
ApplyGroupCustomImages : 0 ms
LoadConnectionInTreeNode : 345 ms
PreCreateGroups : 65 ms
BeginUpdate : 338 ms
TreeView.LoadConnectionList : 751 ms
ThreadQueue.AddRow : 8 ms
All Comments (8)
What version of RDM do you use? I'm asking this because RDM 9.0 is currently in beta and when you activate the intelligent cache, you get a huge performance boost
David Hervieux
I forgot to tell I am on 8.9.13.0 64bit
and intelligent cache is enabled in the MSSQL data source
Thanks
Nitzan
Can you post a screen shot of File -> My Data Source Information form.
In the system options please set the debug level = 64. File -> Options -> Advanced -> Debug Level
Now trace the same actions (load, refresh, edit) and post the result. For example you should see more information logged (Offline Mode & Caching Type for example). You can start the application with the "/profiler" flag to start the profiler automatically.
Sample trace:LoadConnections [SQL001]... Offline Mode : ReadWrite Caching Type : IntelligentCaching Current cache version: 0x0000000000050957Connection cache up to dateLoadConnections [SQL001] : 6 ms
Stéfane Lavergne
i too think it has become slower now with last 2 versions (8.9.12,13)
attached a log with debug=64, /profiler, refresh, edit, refresh
shows, that i takes 14sec to startup
also "waiting for response" seems to be back again...
edited by SMG on 9/9/2013
Kind Regards
Markus
======================
rdm-log.txt
Hi,
You can find my attachments
Thanks
Nitzan
rdm-debug.txt
rdm.png
I'm analysing both your profiler outputs. At first glance we have a few very odd behaviours.
For example: 10 seconds to save no rows in SQLite...Row Count: 0ThreadQueue.AddRow : 9688 ms
The question is why? This is actually done on a background thread but even at that it doesn't make sense.
More details to come. I might end up adding even more profiler traces and get you to re-run some tests...
Stéfane Lavergne
Hi,
Just want to inform that after a reboot of my laptop I got better results
please take a look on my current profiler
sorry for the confusion
Thanks
Nitzan
rdm-debug2.txt
Thanks for the heads up.
Stéfane Lavergne