Trying since more than a week to solve this, so far, no solution.
Two machines. One a little faster than the other. The slow one runs windows xp, visual webdeveloper express 2010, sql server 2008. The fast one runs windows server 2008, visual wev developer express 2010, sql server 2008.
The code in queston involves an automatically generated update function in one of the table adapters, called 'adapter'. Our C# code generates a data table called 'table', with which we update our 'datatable' in the table adapter.
The table has about 100 entries.
We then update our datatable in the .xsd file by calling.
int rowsaffected = adapater.Update(table);//this is the line that takes long on fast computer
return rowsaffected > 0;//since function returns a bool
On the slow machine this line of code takes a few milliseconds.
One the fast machine it takes 5 seconds.
These results are consistent. It has nothing to do with one machine being busy, the other idle.
What could be the reason and how could it be solved? How can the same code, on the same platform, on a faster machine take 500 times longer than on a slower machine?
View Complete Post