There is such a task, a huge amount of data is stored in the database, the user from the web page needs to work with it constantly anyway. In general, sometimes you need to download from about 2-4mb of information, and it takes a long time. Of course, I don’t need to download such a large amount of information right away, and this can be done in parts. How to do it right? At this stage, when I load the page, I throw ajax (as I may not need this data right away), with the help of php, I pull a huge amount of information out of the database and throw it back. Maybe there is a typical solution? It can somehow save the answer to the cache, and return part of the information and the index on the mament where you left off ...

  • It is solved by pagination and pagination. - ilyaplot
  • From the point of view of user interfaces, this may look like an infinite scroll or numbered pages, or loading by the link "load more ...". Well, in the back end this all translates into using SELECT … LIMIT m, n - artoodetoo

0