MEMORY tables for noncritical
data that is accessed often, and is read-only or rarely updated.
Benchmark your application against equivalent
under a realistic workload, to confirm that any additional
performance is worth the risk of losing data, or the overhead of
copying data from a disk-based table at application start.
For best performance with
examine the kinds of queries against each table, and specify the
type to use for each associated index, either a B-tree index or a
hash index. On the
statement, use the clause
USING BTREE or
USING HASH. B-tree indexes are fast for queries
that do greater-than or less-than comparisons through operators
Hash indexes are only fast for queries that look up single values
= operator, or a restricted set of
values through the
IN operator. For why
USING BTREE is often a better choice than the
USING HASH, see
Section 126.96.36.199, “Avoiding Full Table Scans”. For implementation details
of the different types of
MEMORY indexes, see
Section 8.3.9, “Comparison of B-Tree and Hash Indexes”.