Posts: 852
Threads: 26
Joined: Jul 2011
Reputation:
0
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.
Posts: 6,242
Threads: 8
Joined: Jun 2008
You're not pushing the button fast enough.
Posts: 27
Threads: 1
Joined: Jul 2014
Reputation:
0
You can use AJAX (Asynchronous javascript and XML) to accomplish what you want.
and use javascript to show only certain amount of results in the first place and hide the others.
Posts: 579
Threads: 18
Joined: Apr 2017
Reputation:
0
Why would you load all those rows at once anyway my man, what I do is load a few rows with pagination, every time a user requests a page the respective rows are loaded.
Additionally you could offer a search feature