Results 1 to 2 of 2
  1. #1
    Join Date
    May 2012
    Posts
    155

    Unanswered: Exactly the same code, high difference run time?

    Hallo everyone,

    I have built a recursive code, which already run untill termination. The recursive code has resulted around 300.000.000 rows. At that time, it run about 8 hours untill termination.

    Yesterday, I tried to run again the code, and it ended after 26 hours. But with exactly the same result.. All correct.


    Is that normal? I am thinking, something must be run randomly, so that the comparing between the records sometimes luckily fast, sometimes unluckily slow.

    Thank you for your comments for this optimization theme.

    Best regards,
    Ratna

  2. #2
    Join Date
    Mar 2003
    Posts
    280
    Quote Originally Posted by ratnalein View Post
    Hallo everyone,

    I have built a recursive code, which already run untill termination. The recursive code has resulted around 300.000.000 rows. At that time, it run about 8 hours untill termination.

    Yesterday, I tried to run again the code, and it ended after 26 hours. But with exactly the same result.. All correct.


    Is that normal? I am thinking, something must be run randomly, so that the comparing between the records sometimes luckily fast, sometimes unluckily slow.

    Thank you for your comments for this optimization theme.

    Best regards,
    Ratna
    Some thoughts, where the conditions equal in both cases. I.e. did you run alone, or did someone else use the server/db/san etc? Where there any change to the data, i.e. is statistics relevant. If you have a plan from the first run you can compare it with the current plan and see if there is a difference
    --
    Lennart

Posting Permissions

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