Hi Friends ......!
I want to know why loop in sql2008,2005, etc. is very fast as compare to .Net loops. What i want to ask will clear with following Example
Suppose, i Have Query which select Data from multiple tables and put it in another table (table name tblTemp) . Now after this i am updating multiple columns( around 30 Columns) of table tblTemp.
Now, what Logic say , the Sql will look for condition and will match with each row of table tblTemp , it will update rows which match condition.
Same procedure will be used for 35 Columns. It will update all columns in fraction of seconds.
But , If I do same thing in .Net(C#,VB.Net) i.e If I retrieve all data and bind it with Datagridview and i try to update 35 columns then it takes around Minute.
My Question why loops which we used in .net take lot of type.