>>>>>But if you get the file and just import it in some other table, you don't need WITH (BUFFERING=.t.), you didn't change the file before importing, right?
>>>>>What happens if you FLOCK() table before you insert records?
>>>>
>>>>This program is not mine and very long and complex. We may try to use flock(), I'm still thinking, should I forget about with buffering and try a different approach?
>>>
>>>If you don't change table before import you don't need buffering=.t., even if you change table, but it is not in Buffering mode you don't need this clause.
>>
>>In our case we're adding records to tables in table buffered mode.
>
>If the main (or any other joined) table is buffrered and changed you definately need WITH (BUFFERING=.t.) or first TABLEUPDATE() and then SELECT.
I understand that, but this slowed down the process considerably and increased CPU usage. I think, we need to find a different approach.
If it's not broken, fix it until it is.
My Blog