| performance with varchar vs tinytext [message #1318] |
Fri, 25 May 2007 10:28  |
 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.
|
|
|
Members
Search
Help
Register
Login
Home
