When you have a TEXT field in MySQL or PostgreSQL, should you put it in a separate table?

I've heard that if you have a table with a TEXT column that will hold a large chunk of text data, it's better for performance to move that column into a separate table and get it via JOINs to the base record.

Is this true, and if so why?

6
задан dan 11 March 2011 в 03:03
поделиться