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
> > Varchar(255) or Text?
>
>Do you mean VARCHAR(255) or TINYTEXT?
>
>As seen here:
>
> http://www.mysql.com/doc/n/o/node_366.html
>
>TEXT columns can be much larger than 255. But they require an extra
>byte for the length portion of the record. So VARCHAR(255) will be
>ever so slightly faster than TEXT.
>
>Jeremy
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. There is a noticeable lag on slow machines. I was wondering if using
a Text (or TinyText) in MySQL exhibited noticeably slower record retrieval
when hundreds of users are querying the database. Or is it too small to notice?
Brent
>--
>Jeremy D. Zawodny, <[EMAIL PROTECTED]>
>Technical Yahoo - Yahoo Finance
>Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
>
>MySQL 3.23.41-max: up 22 days, processed 514,632,289 queries (266/sec. avg)
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
