Optimize for Large Number of Columns in a Wide MySQL Table

SQL / MySQL Tips and Tutorials / By /

In addition to necessary indexes and proper SELECT queries (only select needed columns), for wide tables, 2 basic tips apply well: Define your column as small as possible. Avoid using dynamic columns such as VARCHAR or TEXT as much as possible when you have large number of columns per table. Try using fixed length columns …

Optimize for Large Number of Columns in a Wide MySQL Table Read More »