The Column Set Cost Report quantifies the efficiency of the column sets in the system. When you run the report, it looks at every column set in your system and counts the number of:
-
Properties
-
Relationships
-
Edges
Each item is assigned a value depending on its performance load on the system, with Properties having the lowest value and Edges having the highest.
The total cost assigned to each column set is then calculated as:
(Count of Properties * Value of Properties) + (Count of Relationships * Value of Relationships) + (Count of Edges * Value of Edges)
How do I run the report?
-
Run the report using a GET request in Postman. The command to run the report is:
http://<server>/<site>/api/v2/SDA/GetColumnSetCostReport
The report is displayed in JSON format, and is ordered in descending order by overall cost. This means that you can easily see the column sets in which optimizations might be made at the top of the report.
Postman is an API platform for building and using APIs. For more information on Postman, see www.postman.com.