How to speed up the output of 17000 - 20000 records from the mysql database on django?

Question

MySQL

Hello, can someone tell me how to display 17000 - 20000 records in the shortest possible time per page or how can I make it so that when the user reaches a certain page and then another 500 records are loaded?

Answer 1

From experience, 9000 DOM nodes are already unbearable lags. 20k entries is more than 20k nodes, more likely to be closer to 100k, so it will hang tightly.
But if the issue is in the backend, prepare the results in the cache, optimize the number of SQL queries and network traffic.