On 25/01/12 14:43 +0100, Bertrand Chenal wrote: > Le Wed, 25 Jan 2012 13:45:25 +0100, > Cédric Krier <[email protected]> a écrit : > > Also I think such behavior will be very resource consuming. > > I'm not sure but I think it's just a matter of changing > > GROUP BY to_location, product > > to > > GROUP BY to_location, product, lot > > in the products_by_location method, except that it must be done > through inheritance.
Indeed it will be ressource consuming because the stock period works at product level and not at lot. And I don't think caching per lot is a smart design choise, the number of row in such table will increase very fast. -- 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/
pgputBcu7Tob9.pgp
Description: PGP signature
