Partition of tables in MySQL
- by Joel
Hello,
I have read that in a case where a table has many columns, but most of the time only one of them is used (say a title column in a forum post), a way to increase performance would be a partition to two tables, where one will contain only the title and the other one will contain the other columns (such as the forum post body).
However, in case I use
select ForumTitle from Forum;
won't that be good enough to prevent the load of all columns (such as the forum post's body) to the memory, and eliminate the need of partition?
Thanks,
Joel