On Fri, Sep 3, 2010 at 12:23 PM, Michael Grant <[email protected]> wrote:
> > Thanks. Other than the 1 extra byte thing... > if I'm using MyISAM and assumming I have a string that's 150 characters is > there any advantage to using varchar(150) over say TEXT or any of the other > text type fields? that's what I'm trying to get at. > > So is a table that's got 20 TEXT datatype fields going to be the same as a > table that has 20 varchar(x) fields? > > There is an advantage in using varchar over text and it is performance. Because text type is written in a different area of the memory that the row buffer there may be a slight performance hit because it needs to do a harddrive read/write. I guess like your "does ## impact performance" thread it depends on the data you are storing. But let me say that you are much more likely to see this performance hit. I also believe that varchar can be indexed while text can't. I'm a little hazy on remembering everything right now cause I moved to an Oracle shop. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336812 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
