>Hi everybody,
>
>I'm wondering what is better and faster:
>

>select Table1
>scatter memvar
>FieldFK = something
>PointerField = something
>release cEntered_User, tEntered_Date
>insert into Table2 from memvar
>
>or
>
>insert into Table2 (field1, field2, fieldN,...) ;
>values ;
>(Val1,Val2, Table1.fieldN,...)

>
>I switched from the first to the second, but it doesn't look like I gain a speed increase. I did multiple other changes, so it's hard to compare original code with the new code. But anyway, what do you think?
>
>Thanks in advance.

I read the thread and you say it takes an hour for 4K+ records!!! Recreating a table from scratch, even writing byte by byte, with more than 4K+ would take much less than an hour. I don't think your problem would be solved by finding the nanosecond differences between these 2 approaches.
With even 255 fields and considering you would lıke to stay in old array limits you could cut down this to roughly 15-16 inserts for 4K+ records, if insert is really the bottleneck.
My .02 cents
Cetin