5 messages in com.mysql.lists.dotnetRE: VACHAR and performance
FromSent OnAttachments
Jorge Bastos20 Dec 2004 02:55 
Patrick Questembert20 Dec 2004 12:52 
Jordan Sparks20 Dec 2004 13:06 
Reggie Burnett20 Dec 2004 13:11 
James Moore20 Dec 2004 13:38 
Subject:RE: VACHAR and performance
From:Jordan Sparks (jspa@free-dental.com)
Date:12/20/2004 01:06:18 PM
List:com.mysql.lists.dotnet

MySQL will automatically change it to a VARCHAR even if you try to set it as a CHAR. Whether you like it or not.

Jordan Sparks

-----Original Message----- From: Patrick Questembert [mailto:patr@nyc.rr.com] Sent: Monday, December 20, 2004 12:53 PM To: dot@lists.mysql.com Subject: VACHAR and performance

Hi all,

If I have a text field holding a name between 8 and 32 chars, would it hurt performance if I defined it as VACHAR (as opposed to fixed size at 32)? Would the answer to this question depend on: - whether or not I have an index defined for this column (I think I will define an index for it) - whether I have another VACHAR column for that row in any case (I do), on the grounds that if one column in the table is of variable length, then the total row size is variable anyhow, and performance will not suffer from yet another variable-length column

Thanks! Patrick

-- MySQL on .NET Mailing List For list archives: http://lists.mysql.com/dotnet To unsubscribe: http://lists.mysql.com/dotnet?unsub=jspa@free-dental.com