Loading request...
A user is asking for advice on organizing tables for a chat application that could scale to millions of users, indicating a need for better table organization strategies.
Hi, I'm building a chat-client for some friends and me. But this question is just not only for that case, but more to increase my general knowledge. So let's assume the chat software grows in size to something like discord. Millions of users, billions of chats. How would I organize the tables? One big table for everything, with good indexing? Or perhaps one table for each chat? I want to be able to make searches in my own chats and instantly find something that was written years ago. greetings.