>> [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
>> covers.
>> 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
>quickly.
>
[JS] That's an interesting idea that hadn't occurred to me. Essentially, it's
creating a dependent table behind your back.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
