Search code examples
mysqlsqlt-sqlvarchar

Varchar type and performance issues

I'm modelling a database and I want to ask about the Varchar type.

Is there any performance difference between Varchar(50) and Varchar(100)?

For example, I got a varchar(50) field and user saved 5 char data to this field and another User saved 25 char to this field. But no one saved 50 char data to this field. So I have to turn this field varchar(25) for max performance?

Solution

  • Assuming SQL Server (since you also listed MySQL), no.

    The overhead is the same as long as the data in the field is the same.