The limit of Mini Program's data loading

what is the limit of data loading when you do a content waterfall stream (similar to moments) in Mini Program and load content lazily?
what do you need to pay attention to? ask for expert advice.

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