Home » Performance » MySQL » performance with varchar vs tinytext
performance with varchar vs tinytext [message #1318] Fri, 25 May 2007 10:28 Go to previous message
myrddin  is currently offline myrddin
Messages: 12
Registered: April 2007
Junior Member
Hey guys, I have tried searching for difference between varchar(255) and tinytext in terms of performance but I haven't found a straight answer to this. Is it because there is no significant difference in performance? I know the difference in terms of spaces being trimmed and case sensitivity.

I have a table with about 200+ columns. Most of the small text types are tinytext rather than varchar. Is there a good reason to be using one type over the other in terms for performance? Would the order by be faster with varchar than tinytext when the table has a big row length? I read somewhere that varchar is stored right along with the row data on disk while tinytext is stored else where on disk and such(I'm not sure about that).

Any thoughts on this? Thanks.

Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic:PERL MY SQL SCRIPT
Next Topic:MySQL Performance Help (Really stuck here..)
Goto Forum:

  


Current Time: Sat Jul 4 15:42:38 EDT 2009

Total time taken to generate the page: 0.01272 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.