[Security Solution] Benchmark performance of importing a large number of prebuilt rules

[banderror]

Epics: https://github.com/elastic/security-team/issues/1974 (internal), #174168

Summary

With #180168, we're going to introduce additional logic to the import endpoint for calculating the rule source object. Some of this logic will be run once for a given import call, some of it will be run multiple times for each rule being imported. Some of it can be IO-heavy (installing the package, fetching historical rule versions and ids), some of it can be CPU-heavy (calculating a diff for each rule).

Based on our prior observations, the rules import endpoint times out when importing a large number of rules. I think the number can be around 2-3k rules. Now, with the additional logic, the endpoint is going to be even heavier and can start timing out with a lower number of rules in the ndjson payload.

We would like to:

• Test the performance of the endpoint with the feature flag turned on, in ESS and Serverless.
• Profile the import endpoint locally to see if there's any inefficient code paths that could be optimized. Maybe there are some low hanging fruits there.

If we find some easy performance optimizations to do, we might reconsider working on #195633.

Testing performance

• I suggest to use a few different "extreme" payloads, such as "all existing prebuilt rules", "all existing prebuilt rules where all of them are customized", "all existing prebuilt rules + some custom rules + exceptions/connectors".
• We need to measure how much time it takes to import the payloads above, in both ESS and Serverless, and find the number of rules in the payload that causes the endpoint to time out.

Profiling

It could be done by sending APM data from your local Kibana to your personal remote Elastic APM and then using APM as a profiler. This remote Elastic APM can be spinned up in production cloud as a normal deployment with APM. Staging cloud is known to be problematic for this use case.

[elasticmachine]

Pinging @elastic/security-solution (Team: SecuritySolution)

[elasticmachine]

Pinging @elastic/security-detections-response (Team:Detections and Resp)

[elasticmachine]

Pinging @elastic/security-detection-rule-management (Team:Detection Rule Management)