AW: Transaction
Solved it myself. I set the service to manual transaction (use-transaction="N") and set TransactionUtil.begin() at the beginning and TransactionUtil.commit() at the end of every loop. Cheers, Ingo -Ursprüngliche Nachricht- Von: Ingo Wolfmayr Gesendet: Mittwoch, 20. September 2023 08:30 An: user@ofbiz.apache.org Betreff: Transaction Hi everybody, I have a question regarding transaction: I have a service that parses a big file and creates products from it. > 100.000 products If I do a TransactionUtil.commit() after each product, do I have to add a TransactionUtil.begin() for the next loop? - Service starts and creates a transaction - Product 1 --> commit - Product 2 --> commit or should I disable the service transaction via use-transaction="N" - Service starts - no transaction - begin --> Product 1 --> commit - begin --> Product 2 --> commit The goal is to reduce memory consumption. Best regards, Ingo
Re: UI/UX question on the Facility module
Hi Emad, Here you go: https://issues.apache.org/jira/browse/OFBIZ-5321 HTH Jacques Le 15/09/2023 à 17:09, Emad Radwan a écrit : Hello Community, 1- Why in Facility Manager we've to select a facility first before doing anything else even if there's only one facility defined; this is even highlighted with a remark in that screen. ' If there is only one facility, you need to select it to continue, no search available' 2 - This is related to having the Facility LOV available in the search parameters for related screens; in the Inventory screen such LOV isn't available and the search result is for the previously selected facility only, while in 'Inventory Items' and 'Inventory Item Details' we have the Facility LOV available. I believe there's some wisdom in this design and would appreciate it if you share it with me. Regards, Emad
Transaction
Hi everybody, I have a question regarding transaction: I have a service that parses a big file and creates products from it. > 100.000 products If I do a TransactionUtil.commit() after each product, do I have to add a TransactionUtil.begin() for the next loop? - Service starts and creates a transaction - Product 1 --> commit - Product 2 --> commit or should I disable the service transaction via use-transaction="N" - Service starts - no transaction - begin --> Product 1 --> commit - begin --> Product 2 --> commit The goal is to reduce memory consumption. Best regards, Ingo