Project:
| View Revisions: Issue #27712 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0027712: slow goods receipt batch insertion | ||
| Revision | 2014-09-30 09:50 by alostale | ||
| Steps To Reproduce | In a DB with the following data: m_inout: 500 records m_inoutline: 220K records m_attributesetinstance: 225K records m_storage_detail: 204K records, all of them for the same product ('TEST_IMEI_01') This testing DB can be downloaded from: https://drive.google.com/a/openbravo.com/file/d/0B2PGxKaZaJn-amwya25HZXE2T3M/view?usp=sharing [^] Execute the following script to create shipments (attached file to create the script): select generateGoodReceipt('TEST_IMEI_01', 'TEST_IMEI_01', '10_IMEITEST', 10) First parameter is a Search Key of a product already existing in F&B Client Second Parameter is a Search Key of an existing Storage Bin third parameter is the Document Number you wish for the Goods Receipt See times before and after applying proposed solution: 10 lines 2600ms -> 120ms 100 lines 23470ms -> 974ms 1000 lines (not tested) -> 5959ms 10000 lines (not tested) -> 60645ms |
||
| Revision | 2014-09-30 09:39 by alostale | ||
| Steps To Reproduce | In a DB with the following data: m_inout: 500 records m_inoutline: 220K records m_attributesetinstance: 225K records m_storage_detail: 204K records, all of them for the same product This testing DB can be downloaded from: https://drive.google.com/a/openbravo.com/file/d/0B2PGxKaZaJn-amwya25HZXE2T3M/view?usp=sharing [^] Execute the following script to create shipments (attached file to create the script): select generateGoodReceipt('TEST_IMEI_01', 'TEST_IMEI_01', '10_IMEITEST', 10) First parameter is a Search Key of a product already existing in F&B Client Second Parameter is a Search Key of an existing Storage Bin third parameter is the Document Number you wish for the Goods Receipt See times before and after applying proposed solution: 10 lines 2600ms -> 120ms 100 lines 23470ms -> 974ms 1000 lines (not tested) -> 5959ms 10000 lines (not tested) -> 60645ms |
||
| Revision | 2014-09-30 09:38 by alostale | ||
| Steps To Reproduce | In a DB with the following data: m_inout: 500 records m_inoutline: 220K records m_attributesetinstance: 225K records m_storage_detail: 204K records, all of them for the same product This testing DB can be downloaded from: Execute the following script to create shipments (attached file to create the script): select generateGoodReceipt('TEST_IMEI_01', 'TEST_IMEI_01', '10_IMEITEST', 10) First parameter is a Search Key of a product already existing in F&B Client Second Parameter is a Search Key of an existing Storage Bin third parameter is the Document Number you wish for the Goods Receipt See times before and after applying proposed solution: 10 lines 2600ms -> 120ms 100 lines 23470ms -> 974ms 1000 lines (not tested) -> 5959ms 10000 lines (not tested) -> 60645ms |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |