6 ms·1M queries of what? Group by, 50 table joins or simple select count(*)?by CSDude 13y ago1M queries of what? Group by, 50 table joins or simple select count(*)?riffraff 13y agothis is the memcache compatible interface, so they should be `select y where key = x limit 1`CSDude 13y agoSo memcache should be faster than 1M queries, since only thing that MySQL does here to add overhead?cpleppert 13y agoNot necessarily, InnoDB has optimizations for in-memory tables and there isn't any write overhead that would make the greater complexity of the transaction/disk layer come into play.wcummings 13y agoThis benchmark is read-only so write-overhead doesn't matter