From: <sinisa
Date: March 23 1999 12:30am
Subject: MEDIUMBLOBs vs. LONGBLOBs
List-Archive: http://lists.mysql.com/mysql/816
Message-Id: <14070.57537.85644.167446@monster.local.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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   |
+---------------------------------------------------------------------+