Insert in a table is slow
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Insert in a table is slow

  1. #1
    Join Date
    Jul 2002
    Posts
    205

    Insert in a table is slow

    I have one table, it is observed that recently the insert rate is slow.

    Just want know, how to diagnosis it, what is the solution...? Any script any one has to diagnosis this problem..?

  2. #2
    Join Date
    Mar 2004
    Location
    India
    Posts
    72
    Check with Triggers and indexes belongs to that table..

    --Sathy

  3. #3
    Join Date
    Jul 2002
    Posts
    205
    No triggers are there. Indexes are there and earlier also it was there..

  4. #4
    Join Date
    Nov 2001
    Location
    UK
    Posts
    152
    We would need more information, such as:

    How are you inserting rows ? Is it from an application or a SQL script ? Are you using buffered inserts or one row at a time ? Is the table very wide (e.g. hundreds of columns) ? How many indexes do you have ? Have you tried dropping the indexes and doing the inserts to see if the speed increases ? Are there any database constraints on the table ?

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width