Results 1 to 1 of 1
  1. #1
    Join Date
    Jul 2003
    Posts
    16

    Red face Unanswered: how to improve insert performance

    Hi,

    I have a procedure which insert values into a summary table. Its results come from a power select what returnns around 100K lines by run!
    There are two INSERT commands from 2 diferentes SELECT because there are two differents status tables (Pass/Fail).

    I have realized some sequential values are skipped and not inserted into the table, but I could not realized why. I believe it can be any performance issue but I don't know how to improve insert performance.

    This stored procedure is been running each minute.

    Please, does anybody has any idea to help me??

    Thanks a lot,
    Felicia
    Attached Files Attached Files

Posting Permissions

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