Mini Program map shows nearby users according to longitude and latitude?

Mini Program needs to display the information of people near the user on the map, but when the amount of data is large, it will stutter. The data will be obtained in segments through the longitude and latitude range, and the data will flash and stutter when updating the data. Is there any way to optimize it?

Nov.15,2021
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-1b3849d-2b87c.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-1b3849d-2b87c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?