Since data is stored in memory in both cases, is it possible to have the same approximative insert/s and concurrency performance for both?
If not, why?
Concurrency for the MySQL MEMORY
storage engine is not good. Like MyISAM, it can only do table-locks. So all concurrent threads doing inserts queue up against each other.