06 Jun 2022 784 views 0 minutes to read Contributors
Static Folders are not supported anymore. Use Dynamic Folders instead.
In this release we have fixed the following errors:
Now a different error is shown:
This only happens when your storage type is "User Database" and the database you want to create the dynamic folder in is a different database. That error is now fixed.
When you choose storage type "User Database" and the database to store the settings in, that is the only database where a new table SQLTreeoFolders will be created.
In this release we have changed the following behaviour:
A Static Folder is different from a Dynamic Folder in where SQLTreeo is saving it's folder information. Static Folder information is written into the extended properties of an object (Table, View, Procedure, Function, etc...). It does not change the functionality of an object, it just records additional information about an object. Additional information on Extended Properties can be found here: sp_addextendedproperty (Transact-SQL) - SQL Server | Microsoft Docs.
In order for SQLTreeo to construct the folder structure it needs to read from all the objects, the extended properties information. In case of many objects (Tables, Views, Procedures, Functions, etc...) it takes a long (too long) time to do this. Dynamic Folders are much more efficient and cover all the functionality of a Static Folder.
In version 0.8.11.116 Static Folders are still shown but you cannot create new Static Folders anymore.
Instead a message is shown to create Dynamic Folders instead:
In new releases of SQLTreeo SSMS AddIn we will enable the option to disable Static Folders via the properties screen and set it as a default on new installations. Users then can have the benefit of the improved speed if they do not use Static Folders.
Several performance optimizations
In this article
Please choose a monitoring environment to connect to:
Enter your email address to recover your password.
Download link successfully sent. Check your email for details.
Reset password link successfully sent to . Check your email for details.
An email with a link for creating your password is sent to
Share link successfully sent to .
Your reply is send.
Download link successfully sent to . Check your email for details.
Download link successfully sent to . Check your email for details.
Download link successfully sent to . Check your email for details.
Download link successfully sent to . Check your email for details.
We received your request. We will contact you shortly