Hello,
Most queries on the acoount_move table usually require access to the
company relation.
It is too far (one must go through period.fiscalyear.company), and it may
seriously impact performance on such a big table.
I suggest to denormalise the table to include the company field.
Thanks
On 08/04/13 23:58 -0700, Marc Rechté wrote:
Hello,
Most queries on the acoount_move table usually require access to the
company relation.
It is too far (one must go through period.fiscalyear.company), and it may
seriously impact performance on such a big table.
I don't understand where
For instance, if we consider the General Ledger report, and the simple
table scan on account_move:
clause = [
...,
('period.fiscalyear.company', '=', data['company']),
]
return Move.search(clause,
order=[('date', 'ASC'), ('id',
On 09/04/13 02:44 -0700, Marc Rechté wrote:
For instance, if we consider the General Ledger report, and the simple
table scan on account_move:
clause = [
...,
('period.fiscalyear.company', '=', data['company']),
]
return
Reviewers: ,
Please review this at http://codereview.tryton.org/778002/
Affected files:
M sale.py
Index: sale.py
===
--- a/sale.py
+++ b/sale.py
@@ -6,6 +6,7 @@
from trytond.pyson import Eval
from trytond.pool import Pool,
Reviewers: ,
Please review this at http://codereview.tryton.org/775002/
Affected files:
M account.py
Index: account.py
===
--- a/account.py
+++ b/account.py
@@ -234,9 +234,10 @@
for type_ in childs:
Reviewers: ,
Please review this at http://codereview.tryton.org/777002/
Affected files:
M account.py
Index: account.py
===
--- a/account.py
+++ b/account.py
@@ -170,6 +170,8 @@
for sequence_name in
Reviewers: ,
Please review this at http://codereview.tryton.org/776002/
Affected files:
M product.py
Index: product.py
===
--- a/product.py
+++ b/product.py
@@ -46,7 +46,7 @@
while avail_qty 0.0:
Reviewers: ,
Please review this at http://codereview.tryton.org/777003/
Affected files:
M product.py
Index: product.py
===
--- a/product.py
+++ b/product.py
@@ -206,9 +206,9 @@
and isinstance(arg[1],
Reviewers: ,
Please review this at http://codereview.tryton.org/779004/
Affected files:
M work.py
Index: work.py
===
--- a/work.py
+++ b/work.py
@@ -109,10 +109,10 @@
cls._order.insert(0, ('sequence', 'ASC'))
On 09/04/13 17:38 +, rest...@zikzakmedia.com wrote:
Reviewers: ,
Please review this at http://codereview.tryton.org/779004/
Affected files:
M work.py
Index: work.py
===
--- a/work.py
+++ b/work.py
@@
11 matches
Mail list logo