|
4) Have a table with primary key of my big table and id fo type. Each person may have upto x rows in this table, where x is the number of types they have.
Is the option if your going for a proper relational data structure.
Third Normal Form and All that crap.
With only 1 mill row using any other kind of strucutre isn't going to maxamize performance.
But don't forget that the queries may end up a bit complicated if your using an older version of MySQL that doesn't allow nested SQL
__________________
ICQ:2116226
|