Why Use low_card_tables?Table 'users' (25,000,000 rows) +--------------+-----------------------------------------------------------------+ | first_name | last_name | deleted | deceased | gender | payment_status | +--------------+------------------+---------+----------+--------+----------------+ | Jennifer | Whitney | 0 | 0 | f | 1 | | Milton | Zimmerman | 1 | 0 | m | 0 | | Emily | Friedman | 0 | 0 | f | 1 | | John | Wong
GitHub - ageweke/low_card_tables: Store low-cardinality columns in a separate table for vastly more flexibility and better performance.
GitHub - ageweke/flex_columns: Schema-free, structured JSON storage inside a RDBMS.
