boulder icon indicating copy to clipboard operation
boulder copied to clipboard

checked_redis_source: use more efficient SQL query

Open jsha opened this issue 3 years ago • 0 comments

Right now checked_redis_source uses sa.SelectCertificateStatus to get a status to check against. However, it only needs a few fields: status, revokedReason, and revokedAt. We can make our query only touch those fields, reducing bytes read from disk and transferred.

jsha avatar Aug 04 '22 00:08 jsha

I'm going to expose the new SA.GetCertificateStatus2 (name pending) method both as a method on the SA object and as a gRPC method. This way we can experiment with having the ocsp-responder talk to the database via the SA, rather than via its own direct database connection, which will allow us to simplify some network and firewall configuration.

aarongable avatar Aug 11 '22 22:08 aarongable