Thinking about my database structure and would love some words of wisdom.
I have PROJECTS and Projects contain Messages
Each project will likely have a couple hundred messages.
Would it be better to do the search on the server side for Messages associated with the project?
Or… should I just pull the projects list of messages?
Once it’s launched, the messages data type will have tens of thousands of messages and it seems like searching all messages may be a mistake when the project will only have a few hundred messages - none at the beginning of the project and it’s liked that 90% of projects have sub 100 messages.