Comparison: MemCP vs. MySQL

From MemCP
Revision as of 21:45, 19 December 2024 by Carli (talk | contribs) (Created page with "MemCP has the following advantages over MySQL: * No 64 character limit for column names * uses only 20% of storage compared to InnoDB and MyISAM storage format * supports natural sort (1, 2, 10, 11 instead of 1, 10, 11, 2) with collations * Up to 10x faster query performance for aggregations")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

MemCP has the following advantages over MySQL:

  • No 64 character limit for column names
  • uses only 20% of storage compared to InnoDB and MyISAM storage format
  • supports natural sort (1, 2, 10, 11 instead of 1, 10, 11, 2) with collations
  • Up to 10x faster query performance for aggregations