prosgarz35 commented on PR #3203:
URL: https://github.com/apache/james-project/pull/3203#issuecomment-5825185843
> Agree to add transaction support.
>
> ACL updates is a good exemple (low write)
>
> However performance profile eg if used on messages needs to be accounted
for under load with massive data. Compatibility with distributed PG vendros
(YugaByte and friends) would also need to be accounted for.
Thanks for the review and insights, @chibenwa!
Completely agree on keeping transaction usage targeted to low-frequency,
high-consistency metadata operations (such as ACL updates) rather than
high-throughput message ingestion pipelines, especially keeping connection pool
pressure and distributed PostgreSQL engines (like YugabyteDB) in mind.
The `executeTransaction` helper is provided here as a foundational
utility without forcing transactions onto hot message paths.
Let me know if you would like any adjustments to this PR before merging!
It is completely additive with 100% backward compatibility preserved —
existing callers and execution methods remain entirely untouched, simply adding
an optional transactional capability where needed.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
