At 01:51 PM 06-12-01 -0800, you wrote:

>I have just noticed the following phenomenon, and am curious if it's
>expected behavior, or if it can (or has been) fixed for the much anticipated
>RC2.
>
>I have a table with a blob field that I insert millions of records into. I
>have modified it's Before Insert trigger to do :
>
> new.blob=null;
>
>This works fine. The problem is that FB is still allocating space in the
>database for the new.blob, so my .gdb file is growing at the exact same rate
>as if I didn't have the trigger there in the first place.
>
>Is there anything that can be done to solve this issue?

Don't include the blob column in your insert statement if you want it to be null!

But are you doing any byte-counting to see whether the .gdb file's growth is unreasonably high? IOW, are you certain there *is* an issue? I recall Ann posting some metrics one time, showing an estimate of expected page-saturation in bulk inserts...

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________