which will store account stuff, such as address email, name, phone, and whatever the hell I come up with.
So you get the idea, the table will be huge. For every account there will be like 10 different rows.
So, I was wandering, is it the best way to do INDEX(accID), INDEX(name), will that give you a tree structure? Because efficiency here will be the key. I forsee my statements to retrieve an attribute to be something like
SELECT value FROM account_attributes WHERE accID='?' AND name='?'
... Is this how you would do it? Or is there a more efficient way?