in a web application where people talk to each other , there will be a lot of messages , suppose for simplicity that each row in a table is a message ,
do you think if a have 5 million messages that one table is enough for them all ? or should i have 5 tables of one million each ?
the server used will be a simple vps or small dedicated server with 8Gb of ram ,two cores processor 2.5Ghz frequency , ssd ,