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

Enabling password authentication for new ec2 box | ssh, ssh config, EC2 setup, new user in EC2, PasswordAuthentication

By -
Your EC2 box only contain .pem auth to enable password authentication follow the steps By default your ec2 box come with .pem authentication, once you create your user and password for that user you can’t able to login with that credentials because EC2 by default disables that functionality. Edit ssh config file by below command $ sudo vim /etc/ssh/sshd_config  Search for  PasswordAuthentication  setting and setit to yes PasswordAuthentication yes Restart ssh server $sudo /etc/init.d/ssh reload
Read more

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

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