The number of records displays on the page affect the load time of a webpage.
To improve response time you can show limited records at a time using pagination.
There are various types of pagination available.
One of them is a load-more type.
It adds new records at the end when it gets clicked until records are found.
In this tutorial, I show how you can implement load more functionality on your webpage with Vue.js and PHP.