slow process

[adamta...@gmail.com]

Hi ALL,

I have a process which take a file and create a PO with 4000 PO lines.

First 500 line is ok, after that things starts slow down. I am now at 1398 and it takes 7 seconds to finish the insert of PO Line.

I am using MOrderLine with MAttributeSetInstance as well as MAttributeInstance.

I suspect, it's slow because of I am using this.getTrxName().

Anyway to turn off the transaction even I am still using MOrderLine.saveex()???

Share with me if you think there is other way to speed up the coding.

Thanks.

[Hiep Lq]

i think you should start and commit transaction with each record.

call save function don't make transaction end. please reference code in other process as csv import.

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/3290b39d-e605-4848-a0df-9ca8b76e1feb%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Lê Quý Hiệp
Email: hie...@hasuvimex.vn
Skype: admin.hasuvimex
Mobile: 0915277401

Company: Thanh Hoa Fishery Import - Export J.s.c  (Hasuvimex) DL 47

Add: Lot E, Le Mon Industrial Zone, Thanh Hoa, Vietnam

[adamta...@gmail.com]

Big problem!

I use this.commitex() on PO then it's ok.

Now, I have coding to generate Material Receipt through PO and MRLIne is like 6000.

When I go to that Material Receipt and click Document Action and set to Complete, it been 1 hour and still haven't finish.

Anyway to speed up this? Like increase postgresql memory or anything?

Which class do the complete of Material Receipt? May be the worst I copy and paste and use the commit things.

Adam.