Results 1 to 1 of 1
  1. #1
    Join Date
    Jun 2003
    Location
    Ottawa
    Posts
    105

    Unanswered: 8i versus 9i - performance

    In my environment I'm testing 8i against 9i for a large INSERT/UPDATE process. (bulk load won't suffice in the circumstance)

    For a large INSERT/UPDATE process the performance on 8i appears to be better, than 9i.

    When inserting/updating approx. 2,500,000 rows:

    -8i will perform the inserts at the same rate of speed throughout (about 400 rows per second)

    -9i will start faster (about 500 rows/second), then gradually slow down as the target table fills up (as slow as 100 rows/second)

    Has anyone else observed this behaviour?
    Last edited by dstachon; 06-17-04 at 12:27.

Posting Permissions

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