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 faced with practical considerations like > performance and simplicity of SQL.
You are comparing the two products and arguing that as OpenERP is more widespread it is better designed. I'm showing you that is not the case. It is not for functional design and it is not for performance considerations. (Which does not mean Tryton is always faster). > Have you checked the SQL implication of > such move.period.fiscalyear.company clause ? Have you shown evidence that this is a problem? Have you seen the performance limitations of OpenERP orm? Have you considered that given that OpenERP ORM is inferior it they may be adding fields as a workaround? > This would be acceptable in a > few queries, but company filtering is necessary in most accesses to data. > Writing a module or a report should be made as simple as possible (RAD), > denormalizing would help I think. I don't understand the argument. You talk about queries and RAD at the same time. RAD alllows you to work without worrying about queries to the database because the ORM does that for you. The problem is that you're suggesting there are performance issues yet to be proved. Instead of showing real world examples of the issue you compare with a product that you expect to be better performant than Tryton, but just let me put you an example: Although OpenERP claims to have very large installs it cannot close stock move periods [1]. Can you imagine that each time a user accesses the list of products the ERP is querying all the moves of the given product with their unit of measure and making the conversion? That's what OpenERP does. So again, saying OpenERP does something in a given way is not an argument, because it is not necessarily based on experience. [1] http://www.openerp2tryton.com/users.html#periods-performance -- Albert Cervera i Areny http://www.NaN-tic.com Tel: +34 93 553 18 03 http://twitter.com/albertnan http://www.nan-tic.com/blog
