CODEWITHSUNDEEP
mysql
Ivan
Ivan

Reputation: 15932

Large mySQL table: big table or multiple tables and a view?

I have a user profile table that has 32 fields. These fields are always updated and accessed at the same time. I'm wondering what's the better design, this 32 field-table or split the table into smaller tables and join through a view? Or even, it's possible that the best is split the big table and join it through a SELECT ... JOIN

Upvotes: 1

Views: 401

Answers (1)

jagbandhuster
jagbandhuster

Reputation: 707

If the data is not hierarchial, it is of no use to split the table. Instead it will result an extra overhead while executing the joins. On the other hand if you have repetitions of records in this table, go ahead for a split. It will preform better.

Upvotes: 1

Related Questions