Re: [tryton-dev] Re: Denormalisation of account_move table

2013-05-02 Thread Marc Rechté
Please give the full explaination and the queries you are analyzing otherwise it is useless. SELECT account_move.id AS id,account_move.create_uid AS create_uid,account_move.create_date AS create_date,account_move.centralised_line AS centralised_line,account_move.post_number AS

Re: [tryton-dev] Re: Denormalisation of account_move table

2013-05-02 Thread Cédric Krier
On 02/05/13 01:39 -0700, Marc Rechté wrote: Please give the full explaination and the queries you are analyzing otherwise it is useless. SELECT account_move.id AS id,account_move.create_uid AS create_uid,account_move.create_date AS create_date,account_move.centralised_line AS

Re: [tryton-dev] Re: Denormalisation of account_move table

2013-05-02 Thread Marc Rechté
I used the interactive pgAdmin query tool

Re: [tryton-dev] Re: Denormalisation of account_move table

2013-05-02 Thread Cédric Krier
On 02/05/13 02:06 -0700, Marc Rechté wrote: I used the interactive pgAdmin query tool So what? -- Cédric Krier B2CK SPRL Rue de Rotterdam, 4 4000 Liège Belgium Tel: +32 472 54 46 59 Email/Jabber: cedric.kr...@b2ck.com Website: http://www.b2ck.com/ pgplija7yv9lZ.pgp Description: PGP

Re: [tryton-dev] Re: Denormalisation of account_move table

2013-05-02 Thread Sharoon Thomas
On Thu 02 May 20 02:06, Marc Rechté wrote: I used the interactive pgAdmin query tool You can still run EXPLAIN ANALYZE. See: http://wiki.postgresql.org/wiki/Using_EXPLAIN -- Sharoon Thomas CEO Chief Software Architect Openlabs Technologies Consulting (P) Limited Ph: +1 813 793 6736 Extn.

Re: [tryton-dev] Re: Denormalisation of account_move table

2013-05-02 Thread Marc Rechté
Paste each query in that tool window and press F7 (or query / explain menu)

Re: [tryton-dev] Re: Denormalisation of account_move table

2013-05-02 Thread Cédric Krier
On 02/05/13 02:21 -0700, Marc Rechté wrote: Paste each query in that tool window and press F7 (or query / explain menu) I don't have that tool. By the way, this is not a way to succeed to convince people. And more over, we don't need to see the result on our database but on your database. --

Re: [tryton-dev] Re: Denormalisation of account_move table

2013-04-30 Thread Marc Rechté
I'd say accounting in Tryton is better than in OpenERP: You misunderstood me, I did not intend to compare the functional aspect of the two products. OpenERP may have more real case implementations than Tryton and therefore is faced with practical considerations like performance and

Re: [tryton-dev] Re: Denormalisation of account_move table

2013-04-30 Thread Cédric Krier
On 30/04/13 07:23 -0700, Marc Rechté wrote: I'd say accounting in Tryton is better than in OpenERP: You misunderstood me, I did not intend to compare the functional aspect of the two products. OpenERP may have more real case implementations than Tryton and therefore is faced with

Re: [tryton-dev] Re: Denormalisation of account_move table

2013-04-30 Thread Robert Schöftner
Am 2013-04-30 16:23, schrieb Marc Rechté: I'd say accounting in Tryton is better than in OpenERP: You misunderstood me, I did not intend to compare the functional aspect of the two products. OpenERP may have more real case implementations than Tryton and therefore is faced with practical

Re: [tryton-dev] Re: Denormalisation of account_move table

2013-04-30 Thread Albert Cervera i Areny
A Dimarts, 30 d'abril de 2013 16:23:54, Marc Rechté va escriure: I'd say accounting in Tryton is better than in OpenERP: You misunderstood me, I did not intend to compare the functional aspect of the two products. OpenERP may have more real case implementations than Tryton and therefore is

Re: [tryton-dev] Re: Denormalisation of account_move table

2013-04-29 Thread Albert Cervera i Areny
A Dilluns, 29 d'abril de 2013 11:13:07, Marc Rechté va escriure: Sorry to come back on the subject, but I think this company denormalisation should be applied to even more tables. It would also benefit to the KIS principle and would avoid mistakes of forgetting to include not obvious where