3 ms·
I am always cautious of memory tables. They don't support transactions, for example, and don't work well multi user. Really, the first stop is to use tokudb b
by willvarfar 13y ago
I am always cautious of memory tables. They don't support transactions, for example, and don't work well multi user.
Really, the first stop is to use tokudb backend in mysql. If its still slow, and if you have a small subset that fits in ram, just put that straight into a hash table in app space.
- mtdewcmu 13y agoAs I understood it, the memory tables are read-only. They're like a cache. So transactions aren't needed.
- willvarfar 13y agoExcept for that awkward time when the tables are refreshed?
- taf2 13y agoCould use two memory DBs and rotate them