Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Explain why it is useful to use mvc instead of webforms? : asp.net mvc

1012


Can we have multiple worker process in an ASP.NET application? If so then how it has been handled by application? And who handles it?

965


What is the caspol.exe tool used for?

982


What is the difference between a default skin and a named skin?

1048


How do we implement bundling in MVC?

1052


Where is cookie used in asp.net?

1062


Why Unload event of MasterPage Calls first in ASP.net ?

1010


What is the use of asp.net web api?

1046


What is session in http request?

972


Describe the difference between inline and code behind - which is best in?

1014


What’s the difference between asp.net web forms and asp.net mvc?

1109


How do we ensure view state has not tampered?

972


What are Authentication and Authorization?

1066


What is the difference between c# and .net?

1021


To bind columns manually which tags do you need to add within the asp:datagrid ?

937