Test results with the modified index
- Last UpdatedApr 24, 2025
- 1 minute read
CPU Time and Query Duration for the queries were extracted from the profiler results. CPU was monitored using the Windows Performance Monitor.
The following results are with the value and dataQuality added to the index in the TimeSeries Collect table.
|
Test Action |
Max CPU % |
Average CPU Time (milliseconds) |
Average Duration (milliseconds) |
|---|---|---|---|
|
readTimeSeriesCollect |
10% |
45 |
177 |
|
TimeSeries Collect row insertion |
6% |
1586 |
1649 |
|
TimeSeries Collect row deletion |
6% |
1611 |
1758 |
Disk Space Requirements
The total index size, the number of rows, the disk space reserved, and the disk space used and unused by the collect table are described in the table below.
|
Name |
Index Size |
Rows |
Reserved |
Data |
Unused |
|---|---|---|---|---|---|
|
collect |
49 GB |
>725 million |
87 GB |
38 GB |
1960 KB |
The sizes of each index in the collect table are described in the table below.
|
Index Name |
Index ID |
Type |
Type Description |
Index Size |
|---|---|---|---|---|
|
CollectTimeTagIdx |
1 |
1 |
CLUSTERED |
119 MB |
|
CollectTagTimeIdx |
2 |
2 |
NONCLUSTERED |
27 GB |
|
CollectTagFieldTimeIdx |
3 |
2 |
NONCLUSTERED |
22 GB |