I Observe NodeCustomProperties table exist separately and the same details present in the Nodes table why we have the duplicate table which is increasing the Database size ?? Anyone have any details about this duplicate tables ?
Orion Development is constantly optimizing the database as new modules are added and the suite matures. Custom Properties are a good example of data that was once module-specific. Over the years new common tables for CustomProperities provided us with standardization and better integration. Some of the legacy tables are now views that are pulling this data from the new tables. Nodes, for example, is a view and not a table. (Depending on your version). If you are concerned about database size, check out what tables are taking the most space and you may want to reduce your retention settings for those specific tables.
Optimize the database used by Orion Platform products (solarwinds.com)
