Tips that can help speed up INSERTs


Interview questions

SQL Server - Tips that can help speed up INSERTs

Next>>         SQL Server tutorial  

SQL Server - Tips that can help speed up INSERTs - Feb 27, 2010 at 11:50 AM by Shuchi Gauri

Explain a variety of tips that can help speed up INSERTs.

Tips to speed up INSERTs:

  • Use RAID10 or RAID1 for physical disk array storing SQL Server database.
  • Ensure Server has enough memory available.
  • Fewer the indexes on table faster are the INSERT queries.
  • Avoid page splits
  • Keep narrows column widths
  • Use batch INSERT

SQL Server - Tips that can help speed up INSERTs - May 05, 2009 at 22:00 PM by Rajmeet Ghai

Explain a variety of tips that can help speed up INSERTs. 

  • Ensure the server has enough memory.
  • Less number of indexes on a table.
  • Column widths should be as narrow as possible.
  • Batch inserts should be used instead of one row at a time.
  • Make use of RAID 10 or 1 since RAID 5 involves overhead of writing parity bits. 

SQL Server - Tips that can help speed up INSERTs - June 21, 2009 at 09:00 AM by Amit Satpute

Explain a variety of tips that can help speed up INSERTs.

  • The insert delayed should be used in scenarios where multiple clients insert a lot of data.
  • Concurrent INSERTs can be applied to a table when SELECTs are running simultaneously condition being that there are no deletions taking place.
  • LOAD DATA INFILE should be used as it is faster than inserts if the data is being loaded from a file.
  • LOAD DATA INFILE can be executed faster by:
    1. Creating a table.
    2. Executing a FLUSH TABLES.
    3. Removing all use of indexes for the table.
    4. Inserting data into the table with LOAD DATA INFILE.
    5. Re-creating the indexes to avoid the disk seeks resulting in a well balanced index tree.
    6. And then executing a FLUSH TABLES command.


Also read

How to copy data from one table to another table?

Data from one table can be copied into another using the INSERT INTO clause................

SQL Server method to insert data

Brief about Insert Statement with an example.
Brief about Select….into statement with an example.
Brief about Bulk copy with an example.
Describe how bcp command prompt utility is used to import and export data.
Describe how bulk insert statement is used to import data..........

What are the steps to process a single SELECT statement?

Answer - SQL Server uses the following steps to process a single SELECT statement....

SQL Server Optimization Tips

Answer - Restricting query result means return of required rows instead of all rows of the table. This helps in reducing network traffic......

What are the ways available in SQL Server to execute SQL statements?

Answer - SQL Server uses different ways to execute SQL statements which are listed below......

Write your comment - Share Knowledge and Experience


Latest placement tests
Latest links
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring