| Subject | Re: [firebird-support] UDF "returning" BLOB slow after first call |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2018-04-23T14:43:03Z |
23.04.2018 16:18, tvdien@... [firebird-support] wrote:
transaction where UDF has been called. More returned data - bigger database, slower access
to it.
Think twice if you really need return BLOB from UDF.
Commit the transaction as soon as possible.
--
WBR, SD.
> It seems to be that call to blob_put_segment that becomes slow. At first usage of the UDFData, returned from UDF as a BLOB, are stored in database and kept there until end of
> it's almost instant, and after that it takes 15ms for every invocation.
>
> What causes this and can I avoid it?
transaction where UDF has been called. More returned data - bigger database, slower access
to it.
Think twice if you really need return BLOB from UDF.
Commit the transaction as soon as possible.
--
WBR, SD.