Simple steps to Faster Database Code

Поделиться
HTML-код
  • Опубликовано: 13 дек 2024

Комментарии • 24

  • @ismaelmetero4121
    @ismaelmetero4121 Месяц назад +3

    Very interesting and a good example of refactoring existing code.

  • @vikram4755
    @vikram4755 Месяц назад +2

    commit frequency was a good one!

    • @DatabaseDude
      @DatabaseDude  17 дней назад +1

      is most cases, the optimal number of commits is 1

  • @Info-Galaxy
    @Info-Galaxy Месяц назад

    Useful and informative, Thank you so much for your efforts, as usual you are always there with very good and simple examples.

  • @TheEsesman
    @TheEsesman Месяц назад

    Great video!

  • @blindender9979
    @blindender9979 24 дня назад

    How to use the sql engine on a insert select of 100 milions of records? Without blowing away the undo table space?
    Im offen using cursor with bulk and limit. Then, forall for the dml (insert or update).
    But is slow very slow!

    • @DatabaseDude
      @DatabaseDude  24 дня назад

      For 100s of millions, I'm probably looking at insert-append (a lot depends on whether you can handle the implications of that)

  •  Месяц назад

    Thanks for the Great video! Is there the example code available somewhere?

    • @DatabaseDude
      @DatabaseDude  Месяц назад

      Look for "oh_bulkmig" in my github rep under "office hours" github.com/connormcd

  • @marekjanosik
    @marekjanosik Месяц назад

    Thank you

  • @virajmokadam4719
    @virajmokadam4719 Месяц назад

    Thank you.

  • @QueryTuner
    @QueryTuner Месяц назад

    ... and I still want to have or buy this OMG shirt somewhere ... 🙂
    Greetings from Hessen/Good Old Germany.

    • @DatabaseDude
      @DatabaseDude  Месяц назад

      Greetings from Perth but on my way to Germany (DOAG)

  • @rydmerlin
    @rydmerlin Месяц назад

    To hint or not to hint?

  • @apolishchuk1880
    @apolishchuk1880 Месяц назад

    I liked the video, but "calling the web service" from the PLSQL block sounds like... the main part that should be fixed here :-D

    • @DatabaseDude
      @DatabaseDude  Месяц назад +1

      PL/SQL was just the simple example - the same principle applies anywhere. But fair point :-)

  • @PeterHitchmanYT
    @PeterHitchmanYT Месяц назад +1

    Just on the last point of the video, no one is going to praise you for making that 8 hour overnight batch job run in 30 minutes, generally I always found that such work was more about me wanting to free up db resources so that it could cope with the additional functionality being crammed into the existing system.

    • @DatabaseDude
      @DatabaseDude  Месяц назад +3

      Cloud changes that equation I think ... because you are literally saving real money