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

Is data edited in the Repeater control?

990


To add a hyperlink column to the DataGrid which tag is used ?

1030


3. What goals do you have in your career?

1813


Is asp.net a programming language or framework?

961


What is meant by server side scripting?

897


Explain the difference between asp & asp.net.

965


What is smpte vc-1?

991


What should you do is you want to remove an existing component but would like to make some funtionalities?

1881


What is web router?

860


What is advantage of code behind coding in ASP.NET?

978


How Can assign alias name for ASP.NET Web API Action?

1406


Write a code for sending an email from asp.net application.

982


What is state management technique?

947


What is a Cookie? Where is it used in ASP.NET?

1038


How can we pass info between 2 asp.net pages?

1012