• Vincent Pelletier's avatar
    Replace sumCatalogResultByWorklist (was O(distinct_criterion_value_count **... · 2071ee26
    Vincent Pelletier authored
    Replace sumCatalogResultByWorklist (was O(distinct_criterion_value_count ** 2)) with an O(SQL_result_line_count * worklists_count) implementation.
    Speed decrease is expected on "small" configurations (because of high SQL_result_line_count when not using SQL-cached worklists).
    Speed increase was measured when using SQL-cached worklists even with many worklists (40+).
    If speed decrease is too critical, it should be possible to keep both implementations and implement a short heuristic to choose between both.
    
    
    git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18923 20353a03-c40f-0410-a6d1-a30d3c3de9de
    2071ee26
WorkflowTool.py 28 KB