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
http://njam.sourceforge.net
http://www.flamerobin.org