Thursday, October 30, 2025
2 changes · saas-18.3
Enhancements to existing features
VoIP browser tabs now try to unregister when closed, and idle registrations expire sooner if that cleanup does not succeed. This helps avoid provider registration limits being reached when users have multiple or recently closed Odoo tabs.
Original PR description
Some providers like OnSIP allow for a limited number of registrations per user. This is a problem in Odoo because each tab opened creates a new registration for one hour. This commit mitigates the problems in two ways: - Sends an "unregister" request onbeforeunload to try to invalidate the registration upon closing the tab. - Reduces the TTL of registrations so that they get invalidated quicker in case the unregistration failed. Forward-Port-Of: odoo/enterprise#98305 Forward-Port-Of: odoo/enterprise#97963
Journal item searches in Accounting now find matching accounts and partners more efficiently, avoiding slow database scans on large datasets. This can significantly reduce wait times for users working with high volumes of accounting entries, with benchmarks showing multi-second searches becoming much faster.
Original PR description
Description ----- Currently, the default journal items view searches ilike over `account_id` and `partner_id`. This generates subqueries and causes Postgres to use a sequential scan instead of hitting the trigram indexes when OR'd. Instead we can leverage the fact that the number of accounts and partners are usually low compared to the number of aml's, by resolving the many2one domain first and injecting the matched ids into the final domain. We make use of the existing `search_account_id` field and apply a similar logic for a new `search_partner_id` field. Since the number of partners can be much larger than the number of accounts, we fall back to the original domain if too many ids are returned. Benchmarks ----- |Counts |Before|After| |------------------------------------|------|-----| |700k amls, 80k partners, 5k accounts|2.87s |0.45s| |7M amls, 800k partners, 50k accounts|29s |4s | opw-5047423