slow inserts
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 34

Thread: slow inserts

Threaded View

  1. #1
    Join Date
    Jan 2006
    Posts
    23

    slow inserts

    I have a heavy insert database - 3rd party application which checks for existance of a record, and if they are not there, it inserts them in 10 major tables. I'm running 36 instances of this application and have about 25,000 inserts per table/per minute. Unfortunately, this throuput is not enough for the business and I'm trying to optimize it. What wonders me is that if I add more application instances the insert rate doesn't improve. Bellow is a part of my statpack.
    Please help me analyze what is the problem and what can I do to improve the performance.
    Thanks a lot,mj

    Code:
    Top 5 Timed Events
    ~~~~~~~~~~~~~~~~~~ % Total
    Event                          Waits Time (s) Call Time
    ------------------------- ---------- -------- ---------
    db file sequential read   10,147,781   96,505     88.00
    CPU time                       7,286     6.64
    db file parallel write       102,185    2,391      2.18
    log file sync                165,362    1,649      1.50
    log file parallel write      297,068    1,251      1.14
    Last edited by gandolf989; 01-10-2006 at 10:28 AM.

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