Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

account_financial_report_webkit takes very long to update on large databases #14

Closed
lepistone opened this issue Sep 1, 2014 · 3 comments
Closed

account_financial_report_webkit takes very long to update on large databases #14

lepistone opened this issue Sep 1, 2014 · 3 comments

Comments

@lepistone
Copy link
Member

Hi, I was confronted to an hour-long module update on a large database, and realized that in that module we have a stored function field last_rec_date, which is recomputed by the init method of AccountMoveLine.

The SQL queries on init try to recompute the field on all records where it is null, which could already be the correct value. In my case I have 3 million move lines with last_rec_date null.

Are we sure that we need these queries in init?

Thanks!
@lepistone
Copy link
Member Author

I just found out there is already #12 for that, cool!

@lepistone
Copy link
Member Author

... and the bug is on launchpad too: https://bugs.launchpad.net/account-financial-report/+bug/1312732

lepistone added a commit that referenced this issue Sep 2, 2014
@lepistone
Merge pull request #12 from acsone/7.0-bug-1312732-lmi
7b27257 
[FIX] Use the migration machinery to initialize default values
closes #14
@lepistone
Copy link
Member Author

Fixed with #12

alexis-via referenced this issue in akretion/account-financial-reporting May 25, 2015
@lepistone
Merge pull request #12 from acsone/7.0-bug-1312732-lmi
11f9779 
[FIX] Use the migration machinery to initialize default values
closes #14
fmdl added a commit to fmdl/account-financial-reporting that referenced this issue May 12, 2017
@fmdl
Merge pull request OCA#14 from fmdl/master
f91c77a 
[FIX] sql injection
fmdl added a commit to fmdl/account-financial-reporting that referenced this issue Nov 8, 2017
@fmdl
Squashed 'account_standard_report/' changes from a110474..6ca1a80
8b5c09b 
6ca1a80 Merge pull request OCA#32 from fmdl/full_sql
e14d2b2 FIX security
499e1fd Fix security
47eaf5a Merge pull request OCA#31 from fmdl/full_sql
1390f53 [FIX]
e9a7979 [Update] readme
aefed9e Merge pull request OCA#30 from fmdl/full_sql
a85fdfc [FIX]
1cba49e [FIX] double creation 999999
a656297 [FIX]
d476877 Merge pull request OCA#29 from fmdl/full_sql
677a629 [FIX]
5deabf9 Merge pull request OCA#28 from fmdl/full_sql
0b9f230 [PEP8] [TRAVIS]
46d23ce [IMP]
a2e02f1 Merge pull request OCA#27 from fmdl/full_sql
4063e43 [FIX] remove zero line
8998def [FIX] add INIT if init
c8277c3 [TYPO] rem unused file
cebb8a8 [IMP] report, add grand total
f0fe668 [IMP] paper format
601dc00 [MIG]
8956342 Merge pull request OCA#26 from fmdl/full_sql
d3a661d [IMP]
7f6cc35 Merge pull request OCA#25 from fmdl/full_sql
ecec373 [FIX] read_group
bfe4571 [IMP] super total
3860ea5 [IMP] add read_group
b66115a [IMP] view
0688abe [IMP]
cbf6e86 [IMP] report
04fdbbc [IMP]
4e442c2 [IMP]
ab58c2e [IMP]
587caa5 [IMP]
30ec70a [IMP] aged balance
6919c79 [IMP] add journal ledger
13f16ab [FIX] open
8999bbf [IMP]  unify total
9a6c732 [IMP] add name on report object
4005b63 [IMP] include inside report object
2c386f3 [IMP]
03477d8 [IMP] add progress
334bd02 [IMP] order
d012d5e [IMP]
5b99907 IMP SQL
7d03125 IMP SQL
d5677c5 [REM] some unused fields
b6403ae Merge pull request OCA#24 from fmdl/master
c93a503 [FIX]
e6f6fa5 [FIX] add result of last year
97a438d [IMP] simplify init balance history
06b436e [FIX] typo
ac020cf [IMP] add balance aged
64ca3f2 Merge pull request OCA#23 from fmdl/master
1cd49d8 [IMP] compacted account
cb48fa8 Merge pull request OCA#22 from fmdl/master
7d7aa91 [TYPO] change centralized to compared
87c8b6c Merge pull request OCA#21 from fmdl/master
4bd6eda [FIX] to long name
19055f4 Typo
baad051 Merge pull request OCA#20 from fmdl/master
a517166 [IMP] add month select
3b27632 [IMP] add excel with total
776be39 [IMP] add centralisation, add reset inter period
ac90426 [FIX] when compute the init is not include
69ac010 Merge pull request OCA#19 from fmdl/master
7986fa1 [IMP] simplify
c0f0ede Merge pull request OCA#18 from fmdl/master
8608b10 [I18n]
d1820f0 Merge pull request OCA#17 from fmdl/master
7d6f1a6 [I18n]
3d9c60b Merge pull request OCA#16 from fmdl/master
7dc6418 [FIX] report name
2bb0c3e [PEP8]
3f8e6bf Merge pull request OCA#15 from fmdl/master
2f36c19 [IMP]
f91c77a Merge pull request OCA#14 from fmdl/master
f314993 [FIX] sql injection
d55606e Merge pull request OCA#13 from fmdl/master
9cafb63 [PEP]8

git-subtree-dir: account_standard_report
git-subtree-split: 6ca1a80
vrenaville pushed a commit to camptocamp/account-financial-reporting that referenced this issue Oct 23, 2018
@leemannd
Merge pull request OCA#14 from jcoux/1093_update_odoo_cloud_platform
bb6bd02 
Update odoo-cloud-platform (BIZ-1093)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@lepistone