MySQL Forums
Forum List  »  Performance

Re: text vs varchar
Posted by: Rick James
Date: April 30, 2016 11:51PM

"when fetching the data from InnoDB, the server will allocate space for all VARCHAR columns" -- Please elaborate.

Are you referring to what happens if a tmp table is needed because of the complexity of the SELECT? In which case, I thought it turned VARCHAR into CHAR, thereby leading to 257 or 767 bytes in the MEMORY temp table versus being forced to use MyISAM (which is slower).

Options: ReplyQuote


Subject
Views
Written By
Posted
2657
April 28, 2016 08:36AM
2371
April 29, 2016 12:41AM
Re: text vs varchar
1670
April 30, 2016 11:51PM
1539
May 02, 2016 04:37AM
1374
May 02, 2016 09:14PM
1463
May 03, 2016 02:19AM
2478
May 03, 2016 04:12AM
1399
May 02, 2016 08:02PM
1636
May 03, 2016 02:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.