Jamroom performance
Jamroom Developers
Should be no problem using utf8mb4, its a newer system. Jamroom supports mysql 5.3 which doesnt have mb4 or otherwise we would likely use that. As it is now there are workarounds in place to deal with emoji issues that wouldn't be needed if we were using mb4.
As to why the different tables, it has to do with indexing, one is faster for read/writes the other for reads only. (from memory)
I think INNODB also supports transactions, but don't recall that we're using them.
