In the Software Factory (2023.1), when I switch branches I get the following message and when executed all documents are closed: Most of the time I don't want this to happen, because I also have my Requirements, Taskboard etc. documents opened, prefiltered, sorted. Closing these documents will result in me opening the same documents again and doing the prefiltering and sorting again. I suggest that only model-specific documents will be closed or I have options to choose whether I want to:close all documents, close all model-specific documents, or do not close documents
Once in a while a run a query to see unused indexes on applications I am working on. The query result shows (most of the time) that a lot of indexes are not used. The Software Factory automatically creates indexes for each reference. Since it takes time to maintain indexes (performance loss), I would like the ability to indicate that I do not want an index.For example,In the Reference, make available a checkbox “Create index” which is by default checked (same as current functionality). When you do not want the index the developer unchecks the box and the (smart) upgrade script will drop the index and not recreate it again.Unchecking the “Create index” checkbox (like unchecking the “Check integrity” checkbox) must be done with care, but when having this option, this could increase performance in certain cases.
In the Software Factory, I would like to have the possibility to configure a View as an indexed view. Indexed views (when used appropriately and with care) can improve performance (just like indexes on tables). For more details: https://www.sqlservertutorial.net/sql-server-views/sql-server-indexed-view/
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.