FWD » Core Development » Database

08/07/2024

03:08 PM Bug #9036: Multi-tenancy: refactor the database in Persistence context-wise

Initially, the @database@ field in @Persistence@ was not context-related. However, when implementing multi-tenancy su... Radu Apetrii

02:54 PM Bug #9036 (Closed): Multi-tenancy: refactor the database in Persistence context-wise

Radu Apetrii

10:24 AM Bug #9034: FindQuery unique fails in a self join context

In this case, @DirectAccessHelper.findByUniqueIndex()@ is used, it assumes that if there is a unique index, only one ... Artur Școlnic

09:27 AM Bug #9034: FindQuery unique fails in a self join context

... Artur Școlnic

09:23 AM Bug #9034: FindQuery unique fails in a self join context

This ticket is derived from #8912-188. Artur Școlnic

09:23 AM Bug #9034 (Test): FindQuery unique fails in a self join context

Artur Școlnic

09:27 AM Feature #1664: data import improvements

I have some thoughts about (quick and rough) profiling the import process using the current implementation. The idea ... Ovidiu Maxiniuc

08/06/2024

02:45 PM Feature #1664: data import improvements

Ovidiu Maxiniuc wrote:
> generating a SQL file instead of the actual SQL import, in a file similar to a SQL dump. Ev... Eric Faulhaber

02:37 PM Feature #1664: data import improvements

I see two paths:
* we go with the DMOs and ignore p2o. This is a bit more conservator. The DMO has all needed inform... Ovidiu Maxiniuc

02:32 PM Feature #1664: data import improvements

Greg Shah wrote:
> The AST has little meaning because the structure is shallow and completely regular. Parsing it b... Eric Faulhaber

02:25 PM Feature #1664: data import improvements

Eric Faulhaber wrote:
> Constantin added (verbally) in a meeting:
>
> ---
>
> * Optimally, don't use BDTs at a... Eric Faulhaber

02:23 PM Feature #1664: data import improvements

The AST has little meaning because the structure is shallow and completely regular. Parsing it brings extra work. I... Greg Shah

02:18 PM Feature #1664: data import improvements

Greg Shah wrote:
> I think we should:
>
> * eliminate the usage of DMOs
> * eliminate the usage of TRPL
> * pos... Eric Faulhaber

02:13 PM Feature #1664: data import improvements

> possibly eliminate the usage of the the .p2o documents (though we still need something to tell us how to read the .... Greg Shah

02:01 PM Feature #1664: data import improvements

Constantin added (verbally) in a meeting:
---
* Optimally, don't use BDTs at all, to avoid the overhead of allo... Eric Faulhaber

01:59 PM Feature #1664: data import improvements

Ovidiu added:
---
The current implementation is struggling too much to maintain compatibility with normal FWD e... Eric Faulhaber

01:56 PM Feature #1664: data import improvements

Greg added:
---
I think we should:
* eliminate the usage of DMOs
* eliminate the usage of TRPL
* possibly ... Eric Faulhaber

01:55 PM Feature #1664: data import improvements

From email, in connection with a customer import issue:
---
I think the core problem is the way we import one t... Eric Faulhaber

01:31 PM Feature #7020: always use "expanded" extent fields

Constantin,
emitting a list of @columns = "f_1_11, f_1_2, f_1_32"@ (as it was computed to avoid collisions in denorm... Ovidiu Maxiniuc

01:20 PM Feature #7020: always use "expanded" extent fields

Eric, I think it may make sense (for expanded mode) to emit at the DMO property the list of SQL names associated with... Constantin Asofiei

01:12 PM Feature #7020: always use "expanded" extent fields

I used a permanent table with same structure as the temp-table from #7020-36 and converted it with *trunk* (r15368), ... Ovidiu Maxiniuc

08/05/2024

03:47 AM Bug #9030: FIND statements should use an internal buffer cursor

> Alexandru, this may not be a query, but a cursor on the index. For example, you can have FIND statements with diffe... Alexandru Lungu

03:27 AM Bug #9030: FIND statements should use an internal buffer cursor

Alexandru, this may not be a query, but a cursor on the index. For example, you can have FIND statements with differ... Constantin Asofiei

03:13 AM Bug #9030: FIND statements should use an internal buffer cursor

This task extracts the issue from #8752-3 and discussion from #6667-1054 to #6667-1087.... Alexandru Lungu

03:10 AM Bug #9030 (WIP): FIND statements should use an internal buffer cursor

Alexandru Lungu

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