Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Flags to control potentially "expensive" functionality for high-volume implementations #390

Closed
rmccu opened this issue Oct 10, 2022 · 0 comments · Fixed by #394
Closed
Assignees
Labels
Layer: Configuration Items related to the custom hierarchy setting LoggerSettings__c or any included custom metadata type optimization Type: Enhancement New feature or request

Comments

@rmccu
Copy link

rmccu commented Oct 10, 2022

New Feature Summary

This issue kind of builds on top of Issue #389.

We are running an older version (v4.6.16), so some of this may be reflected in newer versions.

We also have a very high-volume implementation. We are currently seeing ~2M log records / day, and are still in the process of bringing more users on-board. We are looking to turn our log level down, but we still may have >1M logs / day.

At this volume, even "simple" queries that use an index may be expensive. Recently Salesforce Support raised a concern with the LogEntryEventHandler class saying that it was consuming 50% of DB CPU. That class only has a few SOQL queries and most are using an index or should not scan a large number of records. The issue is that this class is being invoked so many times each day that even small or simple queries are using a lot of DB CPU in the aggregate.

I spoke about this specific class in issue #389. What I want from this issue is to identify additional functionality in Nebula that might be "nice-to-have" and could be disabled to support high-volume implementations of Nebula. I think another example may be in LogEntryHandler where it is querying the record(s) associated with the Log Entry so that the record name can be put on the Log Entry record. While this is "nice-to-have", it is expensive and we would gladly forgo it in order to improve performance/scalability.

@rmccu rmccu added the Type: Enhancement New feature or request label Oct 10, 2022
@jongpie jongpie self-assigned this Oct 20, 2022
@jongpie jongpie added optimization Layer: Configuration Items related to the custom hierarchy setting LoggerSettings__c or any included custom metadata type labels Oct 20, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Layer: Configuration Items related to the custom hierarchy setting LoggerSettings__c or any included custom metadata type optimization Type: Enhancement New feature or request
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants