Home > Workload Solutions > Oracle > Guides > Reference Architecture Guide—Accelerate Oracle Database using Oracle TimesTen as an Application-Tier Cache > HLR benchmark workload overview
The HLR benchmarking application was also used to generate the benchmarking workload against the databases. The workload generated by the HLR benchmarking application simulates an OLTP workload. In terms of SQL operations, the read/write distribution ratio generated by the HLR workload was 90 percent reads (select) and 10 percent writes (insert/update/delete).
The benchmark consists of seven different business transactions, each composed of one or more database operations (statements). The following table shows the different transactions and their percentage compositions of the overall workload.
Transaction name |
Percentage of workload |
Type of transaction |
|
Query/DML |
Read (R) / Write (W) |
||
GetBasicSubscriberData |
35% |
Query |
100% R |
GetAccessData |
35% |
Query |
100% R |
GetNewDestination |
10% |
Query |
100% R |
InsertCallForwarding |
2% |
Both |
50% R + 50% W |
DeleteCallForwarding |
2% |
Both |
50% R + 50% W |
UpdateLocation |
14% |
Both |
50% R + 50% W |
UpdateSubscriberData |
2% |
DML |
100% W |
Total |
100% |
|
89% / 11% |