DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 23

Thread: Insert performance is very bad

Threaded View

  1. #8
    Join Date
    May 2002
    Posts
    2,645
    Got to read the index (or indexes) to do DML, that would account for the sequential read wait times. CPU time would be indicative of a lot of hard parsing for the insert statements (willing to bet each and every statement is different as opposed to the same via a bind variable or called procedure using a variable).
    Last edited by stecal; 11-11-2010 at 01:44 PM.

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