CODEWITHSUNDEEP
ruby-on-railspostgresqlmessage
user658599
user658599

Reputation:

Private messages organisation model

I'm going to organise social network. So the question is: how the tables responsible for private maessages should be organised : (1) one table for each user, (2) one table for 1000 users or it's better (3) to create one table for all the user's messages, considering that the system is high loaded.

Upvotes: 0

Views: 142

Answers (2)

anon
anon

Reputation:

Plan small and use a single table. Worry about scale when you get there. The problems you encounter in 6 months will not be the problems you're thinking about today.

Upvotes: 2

vissi
vissi

Reputation: 2334

I'm going to organise social network.

Omg, another one!

You should use NoSQL and caching solutions like mongodb or membase to be prepared for high load. If you still want to stick to postgres, you should create a partitioned table.

Upvotes: 0

Related Questions