thank you sir. On Fri, Sep 3, 2010 at 12:34 PM, Won Lee <[email protected]> wrote:
> > 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:336813 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
