Hi terry...

My code is all in c#. I have an app that loads data from all kinds of files into a dataset (transforming types when necessary) and then I take the dataset and batch update sql server using the update command on the dataadapter using straight ado.net.

It is very fast, the time comparison between our load in vfp7.0 code and c#.net code is almost identical.

I'd be happy to show you some code if you can understand the c#. Let me know....




>You have my attention. What kind of app did you write?
>
>In my situation, I have to move data from a system that uses variable length files into a Windows Based system for other reports and queries. This is done nightly in the Scheduled Tasks.
>
>I've used Foxpro to do this for the past 6 years and it has worked very well. As an example, one of the data files contain approximately 31,000 records which updates in about 8 seconds.
>
>We are now migrating to .NET using SQL Server for the data. The same appliation in VB.NET that posts to SQL server takes about 15 minutes.
>
>Everyone I have talked to who has SQL experience and VB and/or VB.NET experience talks about how fast SQL server is. Based on the tests I've done, I don't see the speed. My Foxpro apps and DBF tables beat the VB.NET apps and SQL server every time.
>
>The only thing I can think of is that either I'm coding the .NET app wrong, or the saying is true, "nothing runs like a Fox".
>
>All that being said, I would love to see some basic code that is used for mass updates. In the applications I'm testing, I'm using DataAdapters.
>
>What advice does anyone have for speed and efficiency?
>
>Thanks in advance to everyone for commenting.