Thanks for pointing me to that thread @Yongki, unfortunately, there’s also no real performing solution there as well. The ‘chat’ is quite a crucial part of my app and should work with 1000s of messages easily.
I’ve upvoted the request to improve this, but I’m worried it will take too long, which would make me consider other platforms, and my effort so far in Adalo would be a waste.
We use the Advanced Chat Template from NoCodeMonkey and it works quite well.
Not sure about how to limit just 100 messages - but from our experience, loading that amount of messages will make the UX pretty bad.