I'd like to start with the following topic: Loading data in chucks.
I'm sure all of you have been to sites where all of the data is not loaded at once. More data is either loaded automatically as you scroll to the bottom of the page or there is a button that you can click to load more data.
For those of you who have added this feature to a site you worked on, can you please take a moment to answer the following questions? You can write your responses as comments or use the google docs form I created: https://docs.google.com/forms/d/1p0428UJCp80CqHjNMHp-U1LuG5iKAk_WqDPFhRUI-4o/viewform?usp=send_form
1. Did you prefetch all the data at once, and then append chunks of data to the page as needed? Why or why not?
2. Did you run a query to fetch data from the database each time more data needed to be loaded? Why or why not?
3. Did you use another method apart from the two types listed above? If yes, can you please explain your method?
4. How did you determine the starting point of the next query? (only applicable if you answered yes to 2nd question)
5. How did you deal with such situations where data is subject to change? (only applicable if you answered yes to 2nd question) For example, a collection of articles sorted by the number of 'likes' each article has, and loaded in chunks of 2. (1) Number of likes of each article before 1st query (article1: 10 likes, article2: 7 likes, article3: 3 likes, article4: 1 like) (2) Number of likes of each article before 2nd query (article1:10 likes, article2: 7 likes, article3: 25 likes, article4: 5 likes)
6. What database did you use?