Environment versions
Network:
Windows 2003 Server
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only