Split Data in more Data Types (db) makes less Workload?

Need help Database
1

Hi All,
I want to store which posts a user like. Which of the following scenarios is better in terms of workload (ie for retrieving which posts a user like):

  • A. Store ‘Liked Post’ in User Type
  • B. Create a new Type that has as fields ‘User’ and ‘Liked Posts’
    As happens user has a great number of field (including photos etc).

Thanks

2

In terms of workload… probably A

In terms of performance… almost certainly B

Make your choice.

3

I’m not exactly sure why, but I read that line in the voice of Jigsaw from the Saw movie franchise. Very ominous and creepy, man. So, in other words (or in this case, word), awesome.

2 Likes