1. Mailing Lists
  2. Contributors
  3. Re: HR Attendance - Performance Issue in "Theoretical vs Attended Time Analysis"

Contributors mailing list archives

contributors@odoo-community.org

Browse archives

Re: HR Attendance - Performance Issue in "Theoretical vs Attended Time Analysis"

Avatar

Re: HR Attendance - Performance Issue in "Theoretical vs Attended Time Analysis"

by
i2rs, Jeroen Baten
- 03/04/2025 11:29:39

Hi,

Although I do not program Odoo modules, I do program.

I would suggest to go for option 3, and store balances every year or month (depending on performance impact), with an option to 'recalculate' when needed.

In the mean time, you could also have a look at the queries the current module fires and see if indexing can alliviate some pain.

My 0.02 of course.

Regards,

Jeroen Baten

Op 03-04-2025 om 11:22 schreef Emanuel Cino:
Hello Contributors,

We are using the module hr_attendance_report_theoretical_time for checking our employees working time balance (extra or minus hours), but are facing performance issues (on Odoo 14 at the moment).

We’ve noticed that the report in the module can be slow, especially when handling a large number of attendances. In our setup, it computes all attendances since we started using the module, which significantly impacts performance.
While we sometimes need to analyze attendance over a limited period (e.g., the current year or semester), most of the time we need to retrieve the complete balance of an employee since their start date to assess total (=current) extra or missing hours.

Questions for the Community
  1. Have others experienced similar performance issues with this report?
  2. How do you optimize performance? Have you implemented any workarounds?
  3. Would there be interest in adding a mechanism to store computed balances at a pivot date to reduce the number of records processed?
  4. Do you use another method for computing the total extra hours of any employee? What is your approach?
Any insights or suggestions would be greatly appreciated!

Thanks,
Emanuel

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

-- 
Jeroen Baten              | EMAIL :  JBATEN@I2RS.NL
 ____  _  __              | web   :  www.i2rs.nl
  |  )|_)(_               | tel   :  +31 (0)648519096
 _|_/_| \__)              | Frisolaan 16, 4101 JK, Culemborg, the Netherlands

Reference