|Applies To||RSA Security Analytics|
RSA Security Analytics Broker
RSA Security Analytics Concentrator
RSA Security Analytics Reporting Engine
|Issue||How to optimize lookup_and_add queries in RSA Security Analytics.|
When using lookup_and_add queries, this can result in a vast number of subqueries being generated to complete the task. Because of this, running these queries can be very performance-intensive and take a long time to complete.
The recommendations below may be used to modify the queries to improve their efficiency.
Modify the maximum pending queries on devices.
Change the lookup_and_add configuration on the Reporting Engine.
Change the query level for those who are executing the queries.
If you are unsure of any of the steps above or experience any issues, contact RSA Support and quote this article ID for further assistance.
|Legacy Article ID||a66602|