Why loops in Sql are very fast ?

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

, +

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.

Posted 27-Apr-12 20:36pm

Varinder Raii

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Answer 1 · 2012-04-27T20:50:00

SQL server is sitting on the data and it is optimized to use indexes.

Your .net application is on another process and most likely on another machine, so it has to get all the data to do work on hence data must be transferred/marshaled to it over a network [library].

Datagridview are UI objects and do a lot of extra work also like formatting and layout, you will find a performance boost if you do your work on DataSets or DataTables only.