Library

How to "inflate" Firebird database with temporary blobs

This is one of the don't-do-this articles - just as an example. If you encounter the abnormal growth of your Firebird database, check that you did not write a stored procedure, trigger or execute block, which uses BLOBs concatenation.
In some cases, Firebird stores temporary BLOBs inside the database file, so it grows very very quickly.
​
The following example creates a lot of small temp blobs, which are stored in the database file, so it will "inflate" Firebird database by ~2Gb (Be careful and don't run it on production or important databases!) :
 

execute block
returns (
    BLB blob)
as
declare BLB1 blob;
declare I integer;
begin
  I = 0;
  BLB = 'blabla';
  BLB1 = cast('blablablablablablablablablablablablablabla' as blob);
  while (I < 10000) do
  begin
    BLB = BLB || BLB1;
    I = I + 1;
  end
  suspend;
end