>> [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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
