>*chorttle*
>*grin*
>*wicked, evil laughter*
>
>I figured it out! Yeah!
>
>The real slow down it turns out are the insert into (fields) values (values) statements that that I had all over my program. Changed them into insert from array statements and the program now takes 4 seconds per master record, not 30 seconds :-) *jumping up and down in chair*
>
>This is too cool! I knew there was NO way VFP was that slow.
>
>The way I found it was someone else shared with me how to get the trace function to work in the debugger (always set trace between breaks on) so I was able to watch execution of my program... It does pause for a ever so slight small measure of time on the requery() statements, but it takes ever so much longer to work thru the insert statements.
>
>Thanks again for everyone's help. I think if you want to promote VFP, you should tell them all about this place :-)

Well, if I had known (or at least paid attention to what you said) I'd have told you about using Coverage Logging to find the bottle neck. That would have been much easier, though not as entertaining to watch.

Look up SET COVERAGE TO in the help for more info...


>
>>How large are your tables? I have similar situations where I have to open a view on a 50,000+ record SQL Server database as a remote view. It's none too swift, averaging about 15-30 seconds to come across a wide-bandwidth connection.