>>I tried your test and it worked very quickly. Now, as I understand, you need to send line by line to the PDF creation routine of XFRX and you don't need to have an actual text file as in your sample, you can use memo variable directly. Correct?
>
>The code uses XFRX PDF library which is not the same as XFRX. Our production works with memo fileds. You still have to process them line by line. ALINES() didn't work for me for some reason so used old fashioned

>	_MLINE = 0
>	lnOffset = _MLINE
>	FOR lnLine = 1 TO MEMLINES(lcMemo)
>		*lcLine = MLINE(lcMemo, lnLine)
>		_MLINE = lnOffset
>		lcLine = MLINE(lcMemo, 1, _MLINE)
>		lnOffset = _MLINE
>...
>

>
>>I'm wondering if I can just use the code from XFRX to create PDF line by line. I'm sending an e-mail to Martin Jindra to find out is it possible without buying a commercial license. How much it is, BTW?
>
>XFRX and XFRX PDF library are commercial products. You have to buy them in order to use legally. For pricing see http://www.eqeus.com/xfrxorder.php

BTW, back to the original problem. Currentlly the code takes 20 minutes to run for 8K file. I added statistics to see how many records were added:

<snip>
They are not all inserts that happen in the process.