Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
1 Balas
4141 Tampilan

I noticed quite long waiting times for the list view to contracts (account.analytic.account) having many tasks open for invoicing.

What is the best way to deal with this. I check PostgreSQL activity - but there are no bad queries. Everything is in Odoo in "function fields" or in the ORM-Layer.

For now I found a quick solution: I just gave my own user the right "Analytic Accounting" and then I found the menu: Accounting/Configuration/Analytic Accounting/Analytic Accounts

--> This list-view is perfectly fast since it doesn't sum up all open tasks.

Avatar
Buang
Jawaban Terbai

Your problem might be that you are using too many function fields in list view, and your list might be too long.
Recommendation in technical memento is not to use function fields, but if you do i would recommend to use stored=True attribute in function field.

Best regards

Avatar
Buang
Penulis

actually this is not view we wrote - it is the standard of Odoo for contracts. Probably I should file a bug on Github since this view is using function fields. And I guess you are right - the function fields are causing the problems. But you couldn't use stored=True since each task in timesheet (with an analytic account that is a contract) will change the value and the value wouldn't be accurate as a stored one.

Post Terkait Replies Tampilan Aktivitas
1
Mar 15
3421
1
Mar 15
5436
1
Jul 25
412
2
Jul 25
592
1
Jul 25
1665