Importance of varchar length in MySQL table

by

There’s one possible performance impact: in MySQL, temporary tables and MEMORY tables store a VARCHAR column as a fixed-length column, padded out to its maximum length. If you design VARCHAR columns much larger than the greatest size you need, you will consume more memory than you have to. This affects cache efficiency, sorting speed, etc.

More Related Contents:

  1. Best way to test if a row exists in a MySQL table
  2. Subqueries vs joins
  3. Why would an IN condition be slower than “=” in sql?
  4. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  5. How many rows in a database are TOO MANY?
  6. Two single-column indexes vs one two-column index in MySQL?
  7. INNER JOIN ON vs WHERE clause
  8. When should I use CROSS APPLY over INNER JOIN?
  9. Unioning two tables with different number of columns
  10. NULL in MySQL (Performance & Storage)
  11. MySQL function to find the number of working days between two dates
  12. MySQL Trigger to prevent INSERT under certain conditions
  13. How to concatenate columns in a Postgres SELECT?
  14. Is there something wrong with joins that don’t use the JOIN keyword in SQL or MySQL?
  15. MySQL ON DUPLICATE KEY UPDATE for multiple rows insert in single query
  16. MySQL remove duplicates from big database quick
  17. mysql, iterate through column names
  18. How to delete from select in MySQL?
  19. How to delete Duplicates in MySQL table
  20. How to ORDER BY a SUM() in MySQL?
  21. mySQL Returning the top 5 of each category
  22. Error: The used SELECT statements have a different number of columns
  23. Create date from day, month, year fields in MySQL
  24. Can I use a MySQL database with an App Engine application
  25. How to combine aggregate functions in MySQL?
  26. How do I list all the columns in a table?
  27. “SELECT *” vs “SELECT ” for performance
  28. MySQL: Get character-set of database or table or column?
  29. How to get the byte size of resultset in an SQL query?
  30. MySQL subquery returns more than one row

Leave a Comment