ehaerim wrote:

> Thanks for all people kindly answering my questions.
>
> Regarding storing blobs in a separate table,
> Aage => could be better because that way a page can hold more records
> Milan => no need to split blobs into separate table because FB engine is internally doing this job.

Both are valid. You need to consider how big are your blobs and how
often you need to access the data.

1. If you have big blobs, it makes no sense to keep a separate table as
FB would already do this for you.

2. If you have small blobs that can fit into page, then you should
decide depending on the need to access them:

2.a) If you need to access blob data often, then storing it in a
separate table would only slow you down because now you need to read 2+
pages instead of one.

2.b) If you need to access blob data rarely, then having a separate
table would save space and you would be able to fit more records on the
same amount of pages resulting in overall less pages read. If you have
very small blobs compared to the record length, the benefit might not be
noticeable.

I always prefer having clean logic to minor performance improvement.


--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================