Table Performance

October 18, 2021 ยท View on GitHub

You can get an idea of the relative performance of inserts, updates, and selects by looking at the underlying statistics.

An example follows the table.

TypeCachePerfStats
NameRegionStats-<table>
Statisticcreates, puts, deletes
DescriptionNumber of times that an entry is added to, replaced in, or read from the replicated table.
TypeCachePerfStats
NameRegionStats-partition-<table>
Statisticcreates, puts, deletes
DescriptionNumber of times that an entry is added to, replaced in, or read from the partitioned table.

Example: Read and Write Performance

These VSD charts show the rates of reads and writes to the various tables in the application.

You can use these statistics to see that the NEW_ORDER table is growing over time. After the initial orders are loaded, new orders are being placed (created) faster than customers are paying for (destroying) them.