Big Data (10 million rows in entries table) makes CP not opening and REST API 500

[vitalijalbu]

Hi guys, just doing some stress testing to see if statamic can handle big data prev related issue here: statamic/ideas#1312

I don't have complex schemas, just basic products info and 3 collections. I've duplicated the data in db and reached +10MIL records...
Now, api aren't responding, CP doesn't even open 👀

[vitalijalbu]

Native laravel API (openings):
https://toovoz.craftus.co/api/entries

Statamic CMS API (not opening)
https://toovoz.craftus.co/api/collections/items/entries

@duncanmcclean