Note, that if you *really* want to speed things up,
you should make sure all your search fields are
BINARY (case sensitive).
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
> CHAR() is the quickest.
>
> Fixed width is almost always the quickest way to handle data
> from a programming perspective. But it can be wasteful of memory
> or disk space. In the event that it uses so much RAM that your
> server is swapping things in and out, then maybe VARCHAR()
> would be faster.....but in most cases not.
>
> --Matthew
>
> >>> "Nick Kostirya" <[EMAIL PROTECTED]> 01/26/01 11:42AM >>>
> Hi.
>
> You would tell me who is quicker: CHAR(*), VARCHAR(*) or TINYTEXT.
> I need to quicken DB to the maximum and to keep minimum size of the DB.
>
> Thanks.
> Nick.
>
---------------------------------------------------------------------
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
