*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 :-)

>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.