>I'm looking for links/articles/suggestions that I can look into. Off the top of my head, it seems that my odbc connection from the VFP application out-performs the .net version. The code is utilizing the SQL Client provider and not the OLDDB provider.
>
>I know this is very broad but I'd appreciate any help or information that someone else might have.

On a 2 sec vs. x times 180 sec difference I'ld employ simple logging spiced with timing info to get an overview where the time is spent in dotnet. No fiddleing with profilers needed here - less Heisenberg influence. Hope that there is 1 to 5 lumps of code which need to be optimized. Depending on the time distribution decide on further strategy. It might be that adhering to vfp usages/practices is "bad" or just a stupid mistake happened somewhere.

Don't plan, think, read and especially don't hold meetings - measure instead.

HTH

thomas