16.08.2018, 01:35
I have a MySQL table with 6000+ rows and 4 columns. When the user lands on the page, the website loads around 500 rows of data (plus 4 columns). I also have a button where if the user clicks it, it loads the remaining 5500 rows of data. Now this takes a huge time. Is there any way to load the remaining rows in background and when the user clicks on the button, the results are displayed instantly? I don’t want to implement the load more on scroll method because of certain issues.