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
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
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
> >
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
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? It
is unlikely this field will be used for searching and it will not be
indexed
