Sign Up Login


  1. Categories >> Software >> Microsoft Related >> ASP.NET
  2. Suggest New Category

which one is faster execute reader, scalar, execute non
query ?

Question Posted / manoj dagar

Answers were Sorted based on User's Feedback



which one is faster execute reader, scalar, execute non query ?..

Answer / satish v itagi

ExecuteNonQuery is used to inserts, updates, deletes.
ExecuteScaler is used to return values at a stretch; and
can do data modifications too.
ExecuteReader is forward only reading of row by row.

The number of readers that can be open at a time has
limitation (255)

Execute Scaler has no such restriction. You can use
sqlparameters (output) to get more than one field value,
you can use multiple queries to get more than one result.

Because of less overheads, ExecuteReader has a slight
performance advantage but has limitations.

Do not forget to close Readers!

Is This Answer Correct ?    4 Yes 1 No

which one is faster execute reader, scalar, execute non query ?..

Answer / kriss

Execue reader

Is This Answer Correct ?    2 Yes 0 No

which one is faster execute reader, scalar, execute non query ?..

Answer / anirudh g

Scalar will be faster that the execute reader and execute
non query. As scalar only fetch one column single row.
Whereas execute reader may return numbers of record and
though non-query will not return any records it will take
time to identify the data types to validate be4 inserting
the data

Is This Answer Correct ?    2 Yes 0 No

which one is faster execute reader, scalar, execute non query ?..

Answer / kamlesh sharma

most of the above answers are wrong

write answer is execute reader

Is This Answer Correct ?    5 Yes 4 No

which one is faster execute reader, scalar, execute non query ?..

Answer / xc v

execute reader

Is This Answer Correct ?    1 Yes 0 No

which one is faster execute reader, scalar, execute non query ?..

Answer / peter

What is faster:

ExecuteNonQuery("INSERT INTO...; INSERT INTO...; INSERT
INTO");

or

ExecuteNonQuery("INSERT INTO...")
ExecuteNonQuery("INSERT INTO...")
ExecuteNonQuery("INSERT INTO...")

I hope you see my point. Of course it is not a matter of
only three inserts, but maybe 200 - and then I would like
to know if I can save time by adding the INSERT-strings to
one big string and only fire off one ExecuteNonQuery.

I was thinking of coding a test to check, but if some of
you have already done this or just know which is faster,
please let me know.

Thanks

Is This Answer Correct ?    1 Yes 1 No

which one is faster execute reader, scalar, execute non query ?..

Answer / ftryttuyhg

execute non query

Is This Answer Correct ?    3 Yes 4 No

which one is faster execute reader, scalar, execute non query ?..

Answer / ranjitha

Execute Non query

Is This Answer Correct ?    10 Yes 24 No

Post New Answer

More ASP.NET Interview Questions

Explain the purpose of storyboard.targetproperty.

0 Answers  

what exception is thrown when you do a response.redirect

2 Answers   IBM,

What language does asp.net use?

0 Answers  

what are the events in ASP.net page life cycle?

1 Answers  

Using code explain Configuration Management

0 Answers  

Define the steps to set up validation control.

0 Answers  

What kind of programming language is ASP.NET?

0 Answers   3i Infotech,

can u any one tell me clearly where is stored cache datas?

2 Answers   Apollo,

1.how to encrpt query string in asp.net? 2.there are 10000 records then i wnat display 5000 records one gridview and 5000 records another grid view what is the process?

2 Answers   Marlabs,

What is the difference between session and viewstate in asp.net?

0 Answers  

Is it true that a Web service must be written in .NET or not?

0 Answers   Siebel,

Explain login controls.

0 Answers  

For more ASP.NET Interview Questions Click Here
Categories