Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Posts
    1

    Unanswered: Strange response time of INSERT

    Some of the INSERTs on a table are taking too much time to complete.

    The tablespace is OK (insertion in other tables in the same tablespace run quickly)

    The indexes are OK (most INSERTs run quickly, some of them seems problematic)

    It is inserted about 300 rows at each statement execution.

    I don't know what more can I do..........

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Strange response time of INSERT

    Any triggers , check constraints , refrential constraints etc ?

    Check your Visual Explain graph from Command Centre to see the optimized path for ur INSERT

    HTH

    Cheers

    Sathyaram



    Originally posted by mbranco666
    Some of the INSERTs on a table are taking too much time to complete.

    The tablespace is OK (insertion in other tables in the same tablespace run quickly)

    The indexes are OK (most INSERTs run quickly, some of them seems problematic)

    It is inserted about 300 rows at each statement execution.

    I don't know what more can I do..........

  3. #3
    Join Date
    Feb 2002
    Location
    Germany
    Posts
    141

    Re: Strange response time of INSERT

    Are you commiting for every row? Remember: for the insert you need a lock; if you commit, you loose the lock and for the next row you need it again. It can cause an overhead.
    How much freespace do you have in your index pages? If you have many indexes and DB2 must split them again and again, you loose time.
    Just my 2Cents!

    HTH,

    Rodney
    Rodney Krick

Posting Permissions

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