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