Subject Re: [ib-support] Re: Database grows rapidly (3 to 770MB) when using BLOB views/UDFs
Author Claudio Valderrama C.
""Ivan Prenosil"" <prenosil@...> wrote in message
news:20020321173834.BB1D41504C@......
> > From: Claudio Valderrama C. <cvalde@...>
> ...
> > There's something rotten to my eye here. The declaration you gave is:
> > DECLARE EXTERNAL FUNCTION PROPXMAKEBITMAP
> > BLOB, DOUBLE PRECISION
> > RETURNS BLOB
> > ENTRY_POINT 'ProPXMakeBitmap' MODULE_NAME 'ProPXUDF.dll';
> ...
> > I think your true declaration is:
> > DECLARE EXTERNAL FUNCTION PROPXMAKEBITMAP
> > BLOB, DOUBLE PRECISION,
> > BLOB returns parameter 3
> > ENTRY_POINT 'ProPXMakeBitmap' MODULE_NAME 'ProPXUDF.dll';
>
> It seems to me that both styles of declaration creates identical entries
in system tables.

This only depends on how smart is the DSQL layer. Probably it does its own
protection, I haven't checked (transforming A into B). But in the general
case, rest assured that both notations DO NOT produce the same effect (and
they aren't designed to produce the same effect, of course).

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing