FWD » Core Development » Database

08/01/2024

06:39 PM Feature #7020: always use "expanded" extent fields

While investigating a possible regression I identified the following problem I am trying to solve. Assuming we have t... Ovidiu Maxiniuc

07/30/2024

06:01 AM Bug #9016: Improve performance in FQLPreprocessor by using astCache

The @astCache@ added in #7731 is only used in @FqlPreprocessor.parse()@, but it can also be used in ... Dănuț Filimon

05:58 AM Bug #9016 (Test): Improve performance in FQLPreprocessor by using astCache

Dănuț Filimon

07/29/2024

06:26 PM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

I also looked over 8593e/15351.
I don't see anything wrong with the new code.
I remember we had previously anot... Ovidiu Maxiniuc

07/26/2024

06:11 AM Bug #7731 (Closed): performance improvements for FQLPreprocessor

Greg Shah

03:27 AM Bug #7731: performance improvements for FQLPreprocessor

This can be closed. Alexandru Lungu

06:10 AM Bug #8196 (Closed): Reduce number of AbstractTempTable._hasRecords calls to avoid BufferManager.a...

Greg Shah

03:27 AM Bug #8196: Reduce number of AbstractTempTable._hasRecords calls to avoid BufferManager.activeBuffers

This can be closed. Alexandru Lungu

06:10 AM Bug #8030 (Closed): unique index violation when creating a record in two sessions

Greg Shah

03:27 AM Bug #8030: unique index violation when creating a record in two sessions

This can be closed. Alexandru Lungu

06:10 AM Feature #7416 (Closed): Reiterate DatabaseStatistics and leverage to other database profling tools

Greg Shah

03:24 AM Feature #7416: Reiterate DatabaseStatistics and leverage to other database profling tools

This can be closed. Alexandru Lungu

03:26 AM Bug #8044 (WIP): Fix "Failed direct-access due to Error direct accessing for finding record by un...

Alexandru Lungu

07/25/2024

08:57 AM Bug #7488 (Closed): Slow fast-copy with before tables in H2

Greg Shah

06:51 AM Bug #7488: Slow fast-copy with before tables in H2

This can be closed. Alexandru Lungu

08:57 AM Feature #7323 (Closed): Implement soft unique index in FWD-H2

Greg Shah

06:46 AM Feature #7323: Implement soft unique index in FWD-H2

This can be closed. Alexandru Lungu

08:57 AM Bug #7420 (Closed): Optimize Cursor for scrolling AdaptiveQuery

Greg Shah

06:45 AM Bug #7420: Optimize Cursor for scrolling AdaptiveQuery

> 7026e reached into trunk. This can be closed. Alexandru Lungu

08:56 AM Bug #7334 (Closed): Reclaim used sessions to improve performance

Greg Shah

06:44 AM Bug #7334: Reclaim used sessions to improve performance

This can be closed. Alexandru Lungu

08:56 AM Feature #6630 (Closed): optimize return of table parameter

Greg Shah

06:43 AM Feature #6630: optimize return of table parameter

Alexandru Lungu wrote:
> This can be closed now. Alexandru Lungu

08:56 AM Feature #7194 (Closed): Avoid generating an ORDER-BY clause if not required

Greg Shah

06:43 AM Feature #7194: Avoid generating an ORDER-BY clause if not required

This can be closed. Alexandru Lungu

08:56 AM Bug #7329 (Closed): improve FieldReference resolution of getter/setter/extent accessors

Greg Shah

06:42 AM Bug #7329: improve FieldReference resolution of getter/setter/extent accessors

Alexandru Lungu wrote:
> This can be closed.
Alexandru Lungu

08:55 AM Bug #7358 (Closed): Optimize Session.invalidateRecords

Greg Shah

06:42 AM Bug #7358: Optimize Session.invalidateRecords

This can be closed. Alexandru Lungu

08:55 AM Bug #7321 (Closed): Improve FWD-H2 wildcard projection

Greg Shah

06:41 AM Bug #7321: Improve FWD-H2 wildcard projection

This can be closed. Alexandru Lungu

08:55 AM Bug #7355 (Closed): regression in row structure calculation for DATETIME-TZ when join is used on ...

Greg Shah

06:40 AM Bug #7355: regression in row structure calculation for DATETIME-TZ when join is used on temp-tables

Alexandru Lungu wrote:
> This can be closed.
Alexandru Lungu

03:14 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Alexandru Lungu wrote:
> > Hm... you are right, the record can't become 'dirty'; I think direct access to these fiel... Constantin Asofiei

07/23/2024

03:43 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

> Hm... you are right, the record can't become 'dirty'; I think direct access to these fields is required, so the rec... Alexandru Lungu

03:31 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Alexandru Lungu wrote:
> Also, is there a chance to update records with unwanted state (INVALID / DELETED), etc.?
... Constantin Asofiei

03:29 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Review of 8493e:
* I think the solution for @ACCEPT-CHANGES@ is elegant, resolving back to a @Consumer@ and updati... Alexandru Lungu

03:08 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Hmm, I think this is an edge case for the case when the buffer is used with @CAN-FIND@. Its scope is not opened, but ... Alexandru Lungu

02:58 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Created task branch 8593e from trunk rev 15350. Rev 15351 contains:
* ACCEPT-CHANGES must not prune the session cac... Constantin Asofiei

07/22/2024

02:57 PM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Alexandru, about the other issue related to leaking slave buffers. The issue is that a buffer can be defined, but wi... Constantin Asofiei

02:30 PM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

I found the reason of (some of) the @A different DMO instance of type ... is already bound@ at least in a scenario wh... Constantin Asofiei

08:12 AM Feature #7960: Allow query logs to be collected in a H2 database

Review of 7960a:
* Small issues with @P2JLoggingDatabaseHelper@:
** history entry @Module@ is not the same as the ... Alexandru Lungu

07/12/2024

04:32 PM Feature #7020 (Internal Test): always use "expanded" extent fields

After debugging I was able to identify one cause of the regressions being incorrect hydration. This defect was hidden... Ovidiu Maxiniuc

09:21 AM Feature #7020: always use "expanded" extent fields

This is OK. As you can see from the #7020-30 table and the considerations below, the current @normalized@ and the new... Ovidiu Maxiniuc

09:04 AM Feature #7020: always use "expanded" extent fields

Ovidiu, the original concern with denormalized extents (or 'expanded extents') was because the .p2o (and the DMOs) we... Constantin Asofiei

07/11/2024

10:35 AM Bug #8952: Maximum function call inside a dynamic query is broken

It works just fine for me with following changes:... Ovidiu Maxiniuc

10:01 AM Bug #8952: Maximum function call inside a dynamic query is broken

Ovidiu Maxiniuc wrote:
> No, make the @com.goldencode.expr.UnknownType@ public. It is needed by @Function.isAssignme... Artur Școlnic

09:16 AM Bug #8952: Maximum function call inside a dynamic query is broken

No, make the @com.goldencode.expr.UnknownType@ public. It is needed by @Function.isAssignmentCompatible()@.
Also, p... Ovidiu Maxiniuc

09:06 AM Bug #8952: Maximum function call inside a dynamic query is broken

I created a new @UnknownType@ class in persist package. The conversion was successful, but at runtime I get the error... Artur Școlnic

08:45 AM Bug #8952: Maximum function call inside a dynamic query is broken

I am trying to port the @matchSignature@ method to @RuntimeJastInterpreter@, but @UnknownType@ is package-private. Artur Școlnic

06:25 AM Bug #8952: Maximum function call inside a dynamic query is broken

I probably have some additional changes in my working environment. Pasting the big code chunk before @return false;@ ... Ovidiu Maxiniuc

02:39 AM Bug #8952: Maximum function call inside a dynamic query is broken

I tried porting these changes, but the conversion fails. What branch is this from? Artur Școlnic

09:32 AM Feature #7020: always use "expanded" extent fields

Nice summary!
> # @normalized@. This is the old solution. In this case the properties are accessed either in bulk ... Greg Shah

08:10 AM Feature #7020: always use "expanded" extent fields

I have to make a distinction about the way the mapping of the ABL extent fields in converted code. There are 3 possib... Ovidiu Maxiniuc

07/10/2024

10:25 AM Bug #8952: Maximum function call inside a dynamic query is broken

Artur Școlnic wrote:
> I may be wrong, but isn't @BaseDataType maximum(BaseDataType... args)@ exactly for this type ... Ovidiu Maxiniuc

10:20 AM Bug #8952: Maximum function call inside a dynamic query is broken

Try with this patch:... Ovidiu Maxiniuc

10:20 AM Bug #8952: Maximum function call inside a dynamic query is broken

Ovidiu Maxiniuc wrote:
> This NPE is cause by lack of support for variable parameter list method in FWD. The list of... Artur Școlnic

10:15 AM Bug #8952: Maximum function call inside a dynamic query is broken

Ovidiu Maxiniuc wrote:
> This NPE is cause by lack of support for variable parameter list method in FWD. The list of... Artur Școlnic

10:14 AM Bug #8952: Maximum function call inside a dynamic query is broken

Investigating the issue led to several findings:
* The function call does not to be dynamic, a static call of the fu... Artur Școlnic

09:37 AM Bug #8952: Maximum function call inside a dynamic query is broken

This NPE is cause by lack of support for variable parameter list method in FWD. The list of current arguments is comp... Ovidiu Maxiniuc

08:59 AM Bug #8952: Maximum function call inside a dynamic query is broken

The stack trace is... Artur Școlnic

08:58 AM Bug #8952 (WIP): Maximum function call inside a dynamic query is broken

The issue is derived from #8912-86. Artur Școlnic

08:57 AM Bug #8952: Maximum function call inside a dynamic query is broken

... Artur Școlnic

08:55 AM Bug #8952 (WIP): Maximum function call inside a dynamic query is broken

Artur Școlnic

08:51 AM Bug #8593 (Test): H2 performance improvement for table 'truncate by multiplex'

Greg Shah

08:48 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Branch 8593d was merged to trunk rev 15331 and archived. Constantin Asofiei

08:40 AM Bug #8593 (Merge Pending): H2 performance improvement for table 'truncate by multiplex'

You can merge now. Greg Shah

08:37 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Greg Shah wrote:
> Is this ready/safe to merge?
Yes. Constantin Asofiei

08:25 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Is this ready/safe to merge? Greg Shah

08:20 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Constantin Asofiei wrote:
> Rebased 8593d from trunk rev 15330 - new rev 15336. I need to run ETF and some other ap... Constantin Asofiei

03:13 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Rebased 8593d from trunk rev 15330 - new rev 15336. I need to run ETF and some other app testing. Constantin Asofiei

07/09/2024

10:15 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

I am still facing an infinite loop, but this is due to #8945 which seems unrelated.
The issue from #8593-120 is to b... Alexandru Lungu

08:01 AM Bug #8593 (Internal Test): H2 performance improvement for table 'truncate by multiplex'

New issue in the unit tests. I am facing a @Requested to persist DMO of type@ kind of exception. This is because:
* ... Alexandru Lungu

07/08/2024

08:11 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Alexandru Lungu wrote:
> Committed 8593d/rev. 15317 including changes to remove the out-of-scope buffer from the sla... Constantin Asofiei

07:45 AM Bug #8593 (Review): H2 performance improvement for table 'truncate by multiplex'

Committed 8593d/rev. 15317 including changes to remove the out-of-scope buffer from the slave collection. This is eno... Alexandru Lungu

06:55 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

I think the finally should be a sub-block of the block it guards, and execute as part of that, not sequentially, afte... Ovidiu Maxiniuc

07/05/2024

10:37 AM Feature #8931 (New): enable a logical database name to be specified in database configuration/adm...

Eric Faulhaber

07:25 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

I'm not saying that we don't need to fix the finalizable problem. The non-default buffers need to be cleaned from @d... Constantin Asofiei

07:05 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Constantin Asofiei wrote:
> Alexa, the @TemporaryBuffer$Context.domains@ never gets cleaned, also - the salve buffer... Alexandru Lungu

06:51 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Alex, the @TemporaryBuffer$Context.domains@ never gets cleaned, also - the salve buffers for a DMO do not get removed... Constantin Asofiei

06:08 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

The fix is not obvious. The *major* issue is that the scope of the buffer is closed so that it release, commits, etc.... Alexandru Lungu

07/04/2024

07:47 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Alexandru Lungu wrote:
> I think this is related to @finally@ block, as the scope of the buffer is not managed prope... Dănuț Filimon

07:36 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Found the issue:... Alexandru Lungu

07/03/2024

03:41 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

> Does emptyDataset - clearBuffers fall under any of these scenarios, or is there another scenario I have missed?
... Alexandru Lungu