General Database Structure Question
I would like some advice on how to store my data. I want to store a large number of links, with each row containing a link. For example, I have 1000 rows and 1000 users. When a user wants to fetch all the links associated with them, they have to read through 1000 rows. Instead of saving each link in a separate row, I am considering using JSON to store the links. In this case, the table would have columns for the user ID and a JSON object containing 1000 links. This way, each user would only need to read one row at a time. I would like to know if this is a good approach or if there are other suggestions, such as using a cache. IMO the cache would be become the same as save 1000 links in one row because the key and value type.
Thank you for any advice you can provide.
Thank you for any advice you can provide.
