MSSQL: enormous memory consumption on expanding tables treeview

[expired user #10633]'s profile image [expired user #10633] posted 7 years ago in General Permalink

Hi!

Found a strange thing when expanding the tables treeview - suddenly memory consumption is almost 13 times higher than from starting (35MB to 454MB)...

Even more interesting - clicking back and forth between the "Tables (3.263)" node and the database node ("CLI") adds another ~100MB on top every time you click (it does not stop).

Please have a look at the pictures - one showing the treeview (3.263 tables, repeating set of table names separated by schemas) the other displaying the memory consumption. It starts with around 35MB, jumps to 453MB right after expanding and to 560/666MB after clicking twice on the database/tables node.

Using the latest version (9.4.0.5168) in portable (on Windows 2012) but also had it with 9.3.0.5055 - could not reproduce it locally with just 300 tables.

Maybe you find something! Thank you for maintaining this very very very useful piece of software - I luv it!

greets!

2 attachment(s):
  • Screenshot-23.03.2017-11_04_34
  • Screenshot-23.03.2017-11_03_22

Please login to leave a reply, or register at first.