ROTECTED]
> om
> To:
> <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>
>cc:
> <[EMAIL PROTECTED]>,
> <[EMAIL PROTECTED]>
>
> 06/17/2004 1
06/17/2004 11:12 Fax to:
AM
Here's one more quote, it is more relative to Alec's comment/concern
about access speed.
"It is unlikely that the 'field and offset are on different pages'
unless the record contains a large BLOB."
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
th the low byte
first. Point (3) does not apply for ISAM storage or internals.
Ed
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 17, 2004 9:00 AM
To: [EMAIL PROTECT
CTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 17, 2004 8:36 AM
To: emierzwa
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Where are BLOBs / TEXTs stored?
I am curious about this, too. However, I don't think that you answer the
original question.
Are BLOBs stored as separate f
[EMAIL PROTECTED] wrote on 17/06/2004 15:35:36:
>
> I am curious about this, too. However, I don't think that you answer the
> original question.
>
> Are BLOBs stored as separate files, one file per object? Are they
combined
> into a single large BLOB file? are they aggregated into several medi
TECTED]>, <[EMAIL
PROTECTED]>
cc:
06/17/2004 09:17 Fax to:
AM
Found this at http://dev.mysql.com/doc/mysql/en/BLOB.html, basically
it's not stored in the table row along with any other columns in the
same row.
12.4.2 The BLOB and TEXT Types
Each BLOB or TEXT value is represented internally by a separately
allocated object. This is in contrast to all other co