Bootstrap-table background paging total returns a large value, resulting in slow loading of foreground paging calculation

after the end of background paging, a piece of data is specified in rows. Total specifies that when the return value is large, the data that takes a long time to load (only rows) is displayed at the front end. How to optimize this problem?
actual requirements: Log processing, tens of millions of data are processed, and the total value of total is large (but rows only returns the requested part of the data, and the load is slow and even causes the browser to jam)

Sep.23,2021

encounter the same problem
has the landlord solved it?

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b31879-2b51b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b31879-2b51b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?