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 the fear comes. The tables period, fiscalyear and company are pretty small and they will all be joins on foreign keys. > I suggest to denormalise the table to include the company field. Better to show metrics as arguments. -- Cédric Krier B2CK SPRL Rue de Rotterdam, 4 4000 Liège Belgium Tel: +32 472 54 46 59 Email/Jabber: [email protected] Website: http://www.b2ck.com/
pgpia1giyB2jS.pgp
Description: PGP signature
