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 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.
You must be logged in to reply to this topic.