Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

The main source for my reasoning is experience.

The UNION query will be faster because you will be doing a UNION against 12 MyISAM tables instead of doing a single query against a InnoDB table. MyISAM is much faster in read only situations. Once you start writing to it it becomes slower, but the 13th table prevents writes, for that 13th table you might need to go with a slow table like InnoDB. ( yeah I know about that benchmark its a flawed benchmark )



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: