OCA / report-print-send

Odoo Printing Services and Printer related addons
https://odoo-community.org/project/tools-maintainers-30
GNU Affero General Public License v3.0
111 stars 320 forks source link

Performance Impact from Update Printers Jobs Cron #348

Closed lj-oerp closed 1 month ago

lj-oerp commented 9 months ago

Hello,

I am working with Odoo to improve performance for a database making use of the base_report_to_printer module. In particular the Update Printers Jobs is causing a slowdown. This is the specific feedback from Odoo:

"I noticed a scheduled action named "Update Printers Jobs" that runs every minute, resulting in a substantial number of queries. To mitigate the impact on their database, I recommend adjusting the interval to 15 minutes."

Module

base_report_to_printer

Describe the bug

Performance Impact of 1 minute interval Update Printers Jobs Cron

To Reproduce

Affected versions: 15.0

Notes

  1. External network database (odoo.sh)
  2. 40 printers with 1 server configured
  3. Cronjob takes 6s to run

Expected behavior This cron appears to only update printer and job status. Perhaps it should run less frequently?

github-actions[bot] commented 3 months ago

There hasn't been any activity on this issue in the past 6 months, so it has been marked as stale and it will be closed automatically if no further activity occurs in the next 30 days. If you want this issue to never become stale, please ask a PSC member to apply the "no stale" label.