You’re Probably Doing Pagination Wrong

Поділитися
Вставка
  • Опубліковано 26 лис 2024

КОМЕНТАРІ • 28

  • @jarman2904
    @jarman2904 Рік тому +1

    Really appreciate your advice, thank you very much for the time you spend doing those videos. It help me so much optimizing some databases I have.
    Best regards from the Dominican Republic

    • @DatabaseStar
      @DatabaseStar  Рік тому

      You're welcome! I'm glad you like the videos.

  • @ebirimuchechukwuprecious3658
    @ebirimuchechukwuprecious3658 Рік тому +2

    I enjoyed this. Please make a video on cursor pagination (especially without an auto incrementing column)

  • @haydenmaines5905
    @haydenmaines5905 Рік тому +1

    Writing this before watching: The way ive done pagination is theough LIMIT and OFFSET - Limit is set to number of results returned to page, Offset is number of results * current page number

    • @DatabaseStar
      @DatabaseStar  Рік тому

      Yeah, that's the way I usually do it and what's mentioned in the video.

    • @haydenmaines5905
      @haydenmaines5905 Рік тому

      @@DatabaseStar always nice to see I'm on the right track! :)

  • @Dipubuet
    @Dipubuet Рік тому +1

    Wow! This is really tricky!
    Thank you very much for the video!

  • @trietdangminh
    @trietdangminh 7 місяців тому +1

    I have a complex JOIN query involving multiple tables. In the ORDER BY clause, I placed four columns from three different tables. I created indexes for these columns, but I'm still experiencing a decrease in performance. Upon examining the EXPLAIN output, I noticed that the indexes I created are being ignored, and a sequential scan is being performed instead. I suspect that the issue may be related to ordering by multiple columns from different tables. It would be appreciated if you could create a video addressing this topic.

    • @DatabaseStar
      @DatabaseStar  7 місяців тому

      Good idea for a video. Do you know where the expensive steps are? I mean, is it the retrieval of data from the tables or the order by or something else? Perhaps indexes on the columns being joined on could help improve performance - if you haven’t already done that!

  • @cheo-studio
    @cheo-studio 4 місяці тому +1

    Incredibly useful, thanks a lot.

  • @invalidred
    @invalidred 10 місяців тому

    Love your explanation style. Subscribed!

  • @phuhuy9797
    @phuhuy9797 8 днів тому

    can you give me query to demonstrate the problem of missing or duplicating data when it matches the same criteria. i have already tried but have never faced your issue

    • @DatabaseStar
      @DatabaseStar  5 днів тому +1

      Hi, I have a video on my channel about duplicate rows: ua-cam.com/video/w9dwX7xsBgY/v-deo.html

    • @phuhuy9797
      @phuhuy9797 5 днів тому

      @@DatabaseStar thank you

  • @paressh
    @paressh Рік тому

    Hi Friend,
    I need help with Oracle database installation in Intel MacBook Pro.
    I'm trying with Docker.
    I'm already Microsoft SQL using Docker.
    I have difficulty changing Oracle 23c XE password and Database login details.
    I don't know where I can find these.
    Please help me

    • @DatabaseStar
      @DatabaseStar  Рік тому

      Hi, the login details for the docker image should be on the page that you downloaded the image from. I assume it's on the Oracle container registry. I haven't used this because I don't have an Intel MacBook (I have an M1 MacBook so the Docker images don't work for me).

  • @rahulmittal2983
    @rahulmittal2983 Рік тому

    Which application is this?

    • @DatabaseStar
      @DatabaseStar  Рік тому

      This is pgAdmin, an SQL editor for Postgres.

  • @Delicatamente
    @Delicatamente Рік тому

    Super!

  • @karthiks4347
    @karthiks4347 4 місяці тому

    Good👍

  • @chrisl.9750
    @chrisl.9750 Рік тому

    it's not dah-tah...
    it's daaay-tah!

    • @DatabaseStar
      @DatabaseStar  Рік тому

      Haha yeah I hear that sometimes (pronunciation of the word data)