Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Germany, Aschaffenburg (near by Frankfurt)

    Unanswered: mass inserts: extremly strange runtime behaviour !!!!

    We're loading a database with mass data.

    In our development and test environment the insert jobs are running smooth and quick
    (linear behaviour)

    Our production environment has more processors, more memory and more disk space......

    In this environment the same job starts fast and after 1-2 hours it becomes more and more slower.... down to insert rates of 3 rows / 1 hour

    System ressources on the machine are no bottleneck. Only disk I/O is slow, but we would expect a linear behaviour.

    Any idea what is useful to check to get an idea about this phenomenom ?

  2. #2
    Join Date
    Oct 2001
    Check for the tablespace for tables and indexes . Are they on different drives? If they are not well organized then insertion would initially be fast and then it will slow down.

  3. #3
    Join Date
    Aug 2002
    Hi,I just think of index split. ( key inserted in random sequence , and index grows )
    So How about the load data sequence? Is it sorted?
    If possible , how about executing load without Index ( and create it later ) ?

Posting Permissions

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