[Resolved] Buddypress Database Logic

  • Participant
    Level: Initiated
    Posts: 15
    Kerem Erdal on #18120


    When there are a lot of activities in general activity page, there is a button called load more at the buttom of the page. I wonder, when i click on the activity page for the first time, will the server query all the database(all activity data in the activity page) or will it query only the activity data which are seen before the “load more button”(the data above the button). I wonder it in respect to page load time speed. Because, if the server queries all the activity data at the beginning won’t it increase my page speed load time tremendously? (Note: I am asking it for the group activities page too)

    Thank you,

  • Keymaster
    (BuddyDev Team)
    Posts: 24315
    Brajesh Singh on #18121

    Hi Kerem,
    Thank you for asking.

    The queries are paginated. In other words, only a subset of items are fetched in a query. When you click on load more, another subset is fetched with the previous items ofsetted.

    Limiting the query to a subset keeps it fast(most of the time you don’t need to worry about it). If you encounter issues, you can use mysql log to detect slow queries and troubleshoot.


  • Participant
    Level: Initiated
    Posts: 15
    Kerem Erdal on #18122

    Hi Brajesh,

    Thanks a lot for your answer. You can mark this topic as resolved.


You must be logged in to reply to this topic.

This topic is: resolved