Will there be any benefit from using JSON to store data in a table and have a separate meta table?
Here is the source diagram:
Users Table UserId | Username | Etc...
5 | John |
Avatar Table Id | UserId | ImageName | ImageType
1 | 5 | example.png | original
2 | 5 | example_thumb.png | thumbnail
Here is the JSON version:
Users Table UserId | Username | Avatar
5 | John | {"original":"example.png","thumbnail":"example_thumb.png"}
I personally like the json version and prefer to use it, but how much slower than the original version?
In my case, I need custom avatars (and different sizes) for almost every request.
source
share