inserting multiple values in table at a time

By -


What is the optimal way to insert multiple rows (around 1000) from a web
application into a table?

The user enters multiple lines into a text box (up to 10,000). The ASP.NET
application breaks that data into a string array. Each line is an item of
that array.

The user clicks Submit.

I want to insert all those lines into a table in SQL Server.

I know that with MySQL 4.00 and newer, I can simply issue the following
command:

INSERT INTO Table1 (field1) VALUES ('apple'), ('pear'), ('soda'), ('drink')

This will very quickly insert all those values into Table1.field1.

I know that in SQL Server, I can use a BULK INSERT from a file or BCP.
However, I need to do the insert from a web application.

It is better to create one large SqlCommand with all the insert statements:

INSERT Table1 (field1) VALUES ('apple');
INSERT Table1 (field1) VALUES ('pear');
INSERT Table1 (field1) VALUES ('fruit');
INSERT Table1 (field1) VALUES ('drink');

and execute it in one shot.

Or is it better to execute each insert separatly.

Comments

Post a Comment

Popular posts from this blog

Rails Memcache issues

By -
Error :- down_retry_delay not reached for localhost:11211 (0.001 seconds left) down_retry_delay not reached for localhost:11211 (0.001 seconds left) down_retry_delay not reached for localhost:11211 (0.001 seconds left) down_retry_delay not reached for localhost:11211 (0.001 seconds left) [2012-03-20 15:08:28] ERROR NoMethodError: You have a nil object when you didn't expect it! You might have expected an instance of Array. The error occurred while evaluating nil.each     /usr/local/lib/ruby/gems/1.9.1/gems/rack-1.3.6/lib/rack/handler/webrick.rb:71:in `service'     /usr/local/lib/ruby/1.9.1/webrick/httpserver.rb:111:in `service'     /usr/local/lib/ruby/1.9.1/webrick/httpserver.rb:70:in `run'     /usr/local/lib/ruby/1.9.1/webrick/server.rb:183:in `block in start_thread' cache: [GET /assets/kanga_custom/search_merchant.js?body=1] miss, ...
Read more

scp command usage guide

By -
Example syntax for Secure Copy ( scp ) What is Secure Copy? scp allows files to be copied to, from, or between different hosts. It uses ssh for data transfer and provides the same authentication and same level of security as ssh . Examples Copy the file "foobar.txt" from a remote host to the local host $ scp your_username@remotehost.edu:foobar.txt /some/local/directory Copy the file "foobar.txt" from the local host to a remote host $ scp foobar.txt your_username@remotehost.edu:/some/remote/directory Copy the directory "foo" from the local host to a remote host's directory "bar" $ scp -r foo your_username@remotehost.edu:/some/remote/directory/bar ...
Read more

ROR HEROKU Working with file storage like paperclip in heroku for free of cost ( paperclip and dropbox) paperclip-dropbox config | ROR, HEROKU, file storage, paperclip, in heroku, free of cost, paperclip, dropbox, paperclip-dropbox config

By -
In my project i am using paper-clip and deployed to heroku, heroku not allows the file storage but to use aws normally, i don’t want to spend money so i can use drop box storage which will gives 2gb free storage space. So i am using paper-clip with drop box with library papercklip-dropbox gem, steps to follow are given below. Include  gem “paperclip-dropbox” in your gem file Run the command  $bundel install  Create  drop box api app  in  https://www.dropbox.com/developers/apps    and give read write permissions it gives you the  App key  and  App secret   which will used in further configeration Generate the other required details using available details, run the rake task to generate other details “ $ rake dropbox:authorize APP_KEY=your_app_key APP_SECRET=your_app_secret ACCESS_TYPE=your_access_typ  “, this command will generate the  access_token, access_token_secret, user_id Create  dropbox_conf...
Read more