On 5/27/21 4:34 PM, Jiří Činčura wrote:
a) user stream (not segmented) blobs
Is there some docs for that? What I found in "Using_OO_API.html" is just "Last two
parameters are required only if you want to use blob filters or use stream blob, that's out of
scope here.".
That parameters are
> a) user stream (not segmented) blobs
Is there some docs for that? What I found in "Using_OO_API.html" is just "Last
two parameters are required only if you want to use blob filters or use stream
blob, that's out of scope here.".
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
On 27/05/2021 08:48, Omacht András wrote:
> Adriano,
>
> can you tell me what are the extra jobs that make calling through a function
> such a significant slowdown in other cases?
>
> It will be difficult to change from UDF to function if the runtime is doubled
> in such a simple case as it
Adriano,
can you tell me what are the extra jobs that make calling through a function
such a significant slowdown in other cases?
It will be difficult to change from UDF to function if the runtime is doubled
in such a simple case as it is in the fourth case compared to the fifth.
And,
On 27/05/2021 04:29, Virgo Pärna via Firebird-devel wrote:
> On Thu, 20 May 2021 11:45:22 +, Omacht András
> wrote:
>> UDF has been a compromise for us from the beginning (since IB 6.0 or maybe
>> 5.5). If it is possible, we don’t want to depend on things outside of the
>> database because
On 27/05/2021 07:49, Omacht András wrote:
> Hi Virgo and all!
>
>
>
> I also did some tests on 3.0.8.33468
>
>
>
> I had a table with 2.8 million records. I tested with its one of the
> date (not timestamp) fields.
>
>
>
> Case 1.: UDF call
>
> DECLARE EXTERNAL FUNCTION TO_CHAR
>
>
Hi Virgo and all!
I also did some tests on 3.0.8.33468
I had a table with 2.8 million records. I tested with its one of the date (not
timestamp) fields.
Case 1.: UDF call
DECLARE EXTERNAL FUNCTION TO_CHAR
TIMESTAMP,
CSTRING(50)
RETURNS CSTRING(50) FREE_IT
ENTRY_POINT
On 5/27/21 12:13 PM, Jiří Činčura wrote:
Hi,
Is there a sweet spot for the buffer size/length when using IBlob::putSegment?
a) user stream (not segmented) blobs
b) use bigger buffers
Or is it fine to put even 1 byte segments?
It depends upon goals:)
May be recommended as an efficient way
Hi,
Is there a sweet spot for the buffer size/length when using IBlob::putSegment?
Or is it fine to put even 1 byte segments?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Hi All,
I have an fbk, restore with 2.5, 3.0 and 4.0, then execute the next with
isql:
execute block
AS
declare variable stmt varchar(200);
begin
for select 'DROP TRIGGER '||trim(rdb$trigger_name) from rdb$triggers
where rdb$system_flag=0
into :stmt do
begin
in autonomous
On Thu, 20 May 2021 11:45:22 +, Omacht András
wrote:
> UDF has been a compromise for us from the beginning (since IB 6.0 or maybe
> 5.5). If it is possible, we don’t want to depend on things outside of the
> database because it is only a problem to have to ask the customers for any
>
11 matches
Mail list logo