>> [JS] Storing BLOBs in a table must slow down the inner workings of the
>> database engine. After all, the tables are really disk files under the
>> Can the database engine read only parts of a file record?
>> Jerry Schwartz
>Well, there's where things go wrong -- first of all, a "database engine"
>can do -anything- it likes with the actual data.
>For example, the Firebird DBMS stores (longer) Blob data not right
>there in the record, so whenever you don't request the blob (that is,
>not selecting it), it ignores it completely and it can go through the file
[JS] That's an interesting idea that hadn't occurred to me. Essentially, it's
creating a dependent table behind your back.
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341