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.

Reply via email to