MEDIUMBLOBs vs. LONGBLOBs

[<sinisa]

David Johnson writes:
 > Hi!
 > My project has a bunch of tables with MEDIUMBLOB columns.  There is a very,
 > very tiny possibility that we will eventually exceed the MEDIUMBLOB size in
 > the distant future, so my bosses are suggesting we just go with LONGBLOBS
 > everywhere.  Is there any extra performance cost to this besides the extra
 > bite for the size?
 > 
 > Thanks!
 > DJ


Hi!

No, there should not be any. Only few extra bytes in ISAM.

Sinisa

+---------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___        ==  mysql@stripped        |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|        Sinisa Milivojevic      |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|        mailto:sinisa@stripped |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|        Belgrade                |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|_____   Serbia                  |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                           |
|             /*/             \*\                   Developers Team   |
+---------------------------------------------------------------------+