• Vincent Pelletier's avatar
    Implement optimisation of getInventoryList. · 2ec3bfbb
    Vincent Pelletier authored
      This optimisation prevents specific query paterns on stock table from
      reading a number of lines which is proportionnal to the number of operations
      present for a given criterion set.
      This optimisation requires:
       - new ZSQLMethod from erp5_core
       - 2 new catalog tables from erp5_mysql_innodb_catalog
       - inventories with new "full_inventory" property set to true
           full_inventory means that the user which did the inventory acknowledges
           there is no remaining resource besides what is present in the inventory.
    Add test for this optimisation, disabled for now (required business templates
    are not updated yet).
    
    
    git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@16103 20353a03-c40f-0410-a6d1-a30d3c3de9de
    2ec3bfbb
SimulationTool.py 114 KB