Re: Which is faster VarChar(255) or Text?

2002-01-27 Thread Jeremy Zawodny
On Fri, Jan 25, 2002 at 09:42:07AM -0600, BD wrote: > > Jeremy, > > Thanks, I hadn't thought of TinyText. With flat file type > databases that I used to use, if I put something in a memo field, it > takes longer to retrieve the data because it is stored in a separate > physical file. Th

RE: Which is faster VarChar(255) or Text?

2002-01-25 Thread Johnny Withers
ED] Subject: Re: Which is faster VarChar(255) or Text? At 02:31 AM 1/25/2002 , you wrote: >On Thu, Jan 24, 2002 at 05:27:18PM -0600, BD wrote: > > > I will be putting variable length text into a field (up to 255 > > characters but typically around 60 characters) and wonder what makes

Re: Which is faster VarChar(255) or Text?

2002-01-25 Thread BD
At 02:31 AM 1/25/2002 , you wrote: >On Thu, Jan 24, 2002 at 05:27:18PM -0600, BD wrote: > > > I will be putting variable length text into a field (up to 255 > > characters but typically around 60 characters) and wonder what makes > > for faster retrieval? Or does it matter? A field defined as > >

Re: Which is faster VarChar(255) or Text?

2002-01-25 Thread Jeremy Zawodny
On Thu, Jan 24, 2002 at 05:27:18PM -0600, BD wrote: > I will be putting variable length text into a field (up to 255 > characters but typically around 60 characters) and wonder what makes > for faster retrieval? Or does it matter? A field defined as > Varchar(255) or Text? Do you mean VARCHAR(25