Monday, December 16, 2024
1 change · 18.0
Enhancements to existing features
Accounting reports can now use read-only database replicas when a report does not need temporary write operations. This helps spread system load and can improve report responsiveness without changing the report content users see.
Original PR description
api.readonly allows running the queries of an rpc call in readonly mode, on a replicate of the database, in order to better spread the load. So far, accounting reports didn't use them because, in some cases, their computation requires the creation of a temporary table. We improve that by introducing a new option key telling whether the report can run in readonly mode or not, depending on the fact such temporary table is in use or not. The value of this option key then influences which end point is called to compute the report between the regular one, or an api.readonly version of it.