S
S
Svyatoslav2019-12-25 13:28:08
MySQL
Svyatoslav, 2019-12-25 13:28:08

Does the field encoding affect the speed and size of the table?

In my DB all fields are utf8mb4 encoded. Does it make any practical sense for fixed-length CHAR(64) text fields that contain only latin characters and is a unique index to use the latin1 single-byte encoding? Will there be a profit in terms of performance or table size?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Anton B, 2019-12-26
@bigton

If we are talking about a large table, tens of millions of records, then such a kind of "micro-optimization" is needed.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question