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

What is session object? Describe in detail.

1020


Describe how ASP.NET maintains process isolation for each Web application?

1074


What is asp according to you?

1031


How can you use a custom controls in ASP.NET application?

996


Can I read the hard disk serial # of the client computer using asp.net?

1084


Can you set which type of comparison you want to perform by the comparevalidator control?

901


What parameters can you pass in the url of the api? Can get and post use the same url?

988


Explain Session state management options in ASP.NET.

1088


What are the event handlers that we can have in global.asax file?

967


What is another word for redirect?

942


Explain how is the asp.net mvc architecture different from others? : asp.net mvc

1012


What is the difference between an htmlinputcheckbox control and an htmlinputradiobutton control?

1120


What are the two Layouts supported by a Web form in ASP.NET?

1059


How does session authentication work?

921


Describe the diffeerence between inline and code behind?

1014