which one is faster execute reader, scalar, execute non
query ?
Answer Posted / 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 |
Post New Answer View All Answers
Is data edited in the Repeater control?
To add a hyperlink column to the DataGrid which tag is used ?
3. What goals do you have in your career?
Is asp.net a programming language or framework?
What is meant by server side scripting?
Explain the difference between asp & asp.net.
What is smpte vc-1?
What should you do is you want to remove an existing component but would like to make some funtionalities?
What is web router?
What is advantage of code behind coding in ASP.NET?
How Can assign alias name for ASP.NET Web API Action?
Write a code for sending an email from asp.net application.
What is state management technique?
What is a Cookie? Where is it used in ASP.NET?
How can we pass info between 2 asp.net pages?