Geek Answers Handbook

Is there a performance impact if the stored varchar data is less than a certain size limit?

If the column defined using varchar(20000)and the size of the actual data is about 4k-5k, does MYSQL matter? As I read from MYSQL documentation, there is no difference in disk usage when the actual data is smaller than the declared size.

My question is: will there be any effect on the SELECT query in this column? Can I make my requests faster by declaring varcharcloser to the actual size that I will keep in it?

+5
source share
1 answer

. VARCHAR : ( , , 2 ), N , N .

, , 'example', 9 .

SELECT , .

+7

More articles:


All Articles