Subject Re: [firebird-support] Store BLOBs in separate table?
Author Milan Babuskov
ra8009 wrote:
> I have a table that may have as many as 10 BLOBs.

10 BLOB columns or 10 rows with a BLOB column?

> These BLOBs will
> typically contain text of a few paragraphs or less. If I open a
> dataset with all the fields, will I experience performance issues?

"open" in what? Delphi, VB, PHP? Which component?

> Should I split the BLOBs into a separate table and only open each one
> as needed?

Probably not.

Milan Babuskov