Hi Naomi,
I believe the first is marginally faster. I could be wrong, but I think I remember that there's a lot more processing going on with an INSERT due to VARCHARMAPPING and other late changes.
Shame I don't have source code access anymore :-)
>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.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05