Smart inquiries is a WCC feature that allows an implementer to turn off particular sets of
WCC data model queries that are not in use. This simple change avoids the execution of
extraneous queries, significantly reducing transaction response time and increasing TPS in
workloads in almost all transaction workload scenarios. Since this feature can modify the
functionality of the product and your use of the WCC data model can evolve over time, use
careful consideration when implementing this feature.
Consider the following points for using smart inquiries:
Because most WCC services include embedded inquiries, this feature often has benefits
in all kinds of WCC services.
The performance benefit is contingent on how many of your transactions are querying the
unused portions of the WCC data model, how often they are queried, and how many
unused portions you turn off.
This feature reduces response time and increase TPS in those affected transactions.
Optimizations typically result in a significant savings in CPU usage on the application and
database layers, as well as an overall reduction in WCC database workload that is
proportional to the amount of queries reduced.
No comments:
Post a Comment