I'm not quite sure, it just feels more efficient if u could virtually link a user with his own item table, instead of checking one by one every item the user has gotten on a database lots of users are going to use, lets say i have 1000 users and 1000 items, whenever i wanna see items for user 123, i would have to loop through the entire character_item table, to check for his CID, i am fairly new to the database subject but that just feels unefficient, i guess i'm just thinking like object oriented.
That's why you use a MySQL database. I'm not sure why you're looping through the entire characther_item database anyway?
Joining tables are actually the how relational databases are implemented. Again I recommend reading up on the subject. They are the efficient method of associating tables together when using a database.
- We have a Character.
- We know his unique ID.
- We perform a SELECT query.
At no point do you have to iterate through the character_item table?