Hi Dmitry,



That was my first try. Unfortunately it is a lot worse. It allocates 2GB
of RAM and that keeps on working corrupting memory. Scary stuff.



Cheers,



Calin Pirtea



From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Dmitry Yemanov
Sent: Tuesday, 18 August 2009 12:10 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Memory allocation problem in Firebird
2.1.2





Calin Pirtea wrote:

>
> What we are trying to do is get a short message from the content of

the

> blob which is in the first 100 chars of the blob and after various
> changes to it we place this in another field that is then aggregated.
>
> We are looking for help in identifying a workaround for this issue.

Have you considered writing an UDF which receives a blob and returns a
varchar? It shouldn't produce any temporary blobs and its input blob
will be closed right after the UDF is executed, so I don't expect any
memory to leak here.

Dmitry





[Non-text portions of this message have been removed]