From: Michael Widenius
Date: March 23 1999 4:21am
Subject: MEDIUMBLOBs vs. LONGBLOBs
List-Archive: http://lists.mysql.com/mysql/821
Message-Id: <14071.5746.614927.930522@monty.pp.sci.fi>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

>>>>> "sinisa" == sinisa  <sinisa@stripped> writes:

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


sinisa> Hi!

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

sinisa> Sinisa

Hi!

Note however that the current MySQL protocol and the ISAM level
restricts a MySQL row to little under 24M.

Why do you need such large blobs?  (Just curious)

Regards,
Monty