gavin_wusj
7th June 2013, 06:27
Hi,

We use the AFS for purchase invoice auto matching with receipts, but we found it was high process speed when less than 500 records, but it is very slowly to process records more than 1000, and even we spent 5 hours to process 3000 records, it effective our progress.
So, my question, its performance relates with AFS buffer size? if yes, what can we adjust to improve? if no, what can we do for performance?

Thank u very much

Gavin
6.7 2013

mark_h
7th June 2013, 16:39
What we used to do was split the files and process each file. You can also look at how you are opening and closing the sessions - I can't remember which sessions it was, but I found it worked consistently if I opened the session, processed a record, closed the session. Rather than open a session, process all the records, then close the session. If I recall correctly after two or three runs it would abort.

gavin_wusj
8th June 2013, 04:23
I guest we can start and end session each 500 entries, maybe it can improve performance, we will try it, thank you very much.

Gavin