Dynamic / Fixed Tables
Read an interesting post by AlexK on WMW on the pros and cons of fixed/dynamic MYSQL tables. I was looking for some info to decide whether to keep my multiple tables or join them. Joining them will simplify inserts/updates but what I’m also wondering is its impact on speed. According to AlexK, fixed tables will auto convert to dynamic when I add Text/Blob/varchar (which I usually do), so exporting just those to a separate table and running left joins is his recommendation.
MYSQL reference regarding Fixed MYSQL tables
What's Your Take?