I passed a reference to this thread to two of my former colleagues. However, I'm not entirely convinced it applies to our situation, since we're using tables in buffered mode 5.
>>That's very important. In out routine we open tables with different aliases.
>
>I agree.
>
>
>>>Also try insert into dbf('MyOut') from memvar
>
>I tried "Insert into (dbf('myout')) from memvar" and it executed slowly as well (5-6 seconds as opposed to the 1/2 second by dropping the alias or not opening the table at all.)
>
>>BTW, I saw today (from Rick's Borup blog) a pointer to a discussion about insert into ... from memvar and using different aliases. It didn't mention slowness, though. (on
www.foxforum.com)
>
>Thanks for the link to foxforum.com. I haven't heard 'foxforum' since the compuserve days. It's good to have more resources in addition to the UT.
If it's not broken, fix it until it is.
My Blog