FWD » Core Development » Database

05/25/2024

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

ETF testing passed. Constantin Asofiei

05/23/2024

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

Hmmm, I think I see the problem. Indeed, it is not right to delete the DMO as it is not even inserted in the database... Alexandru Lungu

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

Actually I get this in the server log:... Constantin Asofiei

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

Alexandru Lungu wrote:
> Constantin, can you pick this up for another customer application that drove the effort in ... Constantin Asofiei

07:23 AM Bug #7473 (Test): rewrite toString() implementation for Dataset, StaticTempTable and TempTableBui...

Branch 7473a was merged to trunk rev 15236 and archived. Andrei Iacob

07:16 AM Bug #7473: rewrite toString() implementation for Dataset, StaticTempTable and TempTableBuilder to...

You can merge to trunk now. Greg Shah

02:41 AM Bug #7473: rewrite toString() implementation for Dataset, StaticTempTable and TempTableBuilder to...

This is ready to merge. Let us know when we can merge. Andrei Iacob

05/22/2024

11:07 AM Bug #7473: rewrite toString() implementation for Dataset, StaticTempTable and TempTableBuilder to...

Since this hasn't merged yet, let's pause the merge so other branches can go.
Eduard: Let me know when you are a... Greg Shah

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

I am talking about 8593d. Alexandru Lungu

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

I am picking this up for a customer unit tests.
As #8593 is broadly about performance in FWD-H2, Constantin, can you... Alexandru Lungu

05/21/2024

11:22 AM Bug #7473 (Merge Pending): rewrite toString() implementation for Dataset, StaticTempTable and Tem...

This can merge after 8001a. Greg Shah

10:56 AM Bug #7473: rewrite toString() implementation for Dataset, StaticTempTable and TempTableBuilder to...

Alexandru Lungu wrote:
> I think the changes are only for debugging purposes, right? Ovidiu, please correct me if I ... Ovidiu Maxiniuc

07:41 AM Bug #7473: rewrite toString() implementation for Dataset, StaticTempTable and TempTableBuilder to...

I think the changes are only for debugging purposes, right? Ovidiu, please correct me if I am wrong. Despite trying i... Alexandru Lungu

07:13 AM Bug #7473 (Internal Test): rewrite toString() implementation for Dataset, StaticTempTable and Tem...

What testing is needed? Greg Shah

03:17 AM Bug #7473: rewrite toString() implementation for Dataset, StaticTempTable and TempTableBuilder to...

I committed the changes. Eduard Baciu

05/20/2024

03:20 PM Bug #7473: rewrite toString() implementation for Dataset, StaticTempTable and TempTableBuilder to...

Review of 7473a, r15210.
The majority of the issues from previous review were addressed, I have not seen any logic... Ovidiu Maxiniuc

02:32 PM Bug #8593 (Internal Test): H2 performance improvement for table 'truncate by multiplex'

The changes seem logical. I think the code is OK. Ovidiu Maxiniuc

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

Ovidiu: Please review. Greg Shah

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

8593d needs a review first. Alexandru Lungu

05/17/2024

12:29 PM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Is there any further review needed for this or do we just need testing? Greg Shah

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

Committed 8593d/rev. 15206 to fix #8593-54. It contains the patch from #8593-56.
Recap: there was an issue on datas... Alexandru Lungu

05/15/2024

04:12 PM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Greg Shah wrote:
> This resolves the regression documented in #7143-900?
Yes Constantin Asofiei

03:53 PM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

This resolves the regression documented in #7143-900? Greg Shah

03:07 PM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Branch 8593c was merged to trunk revision 15212 and archived.
Branch 8593c_h2 was merged to fwd-h2 trunk revision ... Constantin Asofiei

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

Greg Shah wrote:
> You can merge to trunk now.
Starting. Constantin Asofiei

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

You can merge to trunk now. Greg Shah

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

ETF testing passed, the original #7143-903 is fixed, and another app works OK with this. Constantin Asofiei

04:17 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Reset %Done. Alexandru Lungu

05:55 AM Bug #7473: rewrite toString() implementation for Dataset, StaticTempTable and TempTableBuilder to...

The modified version of
@RecordBuffer.java - sqlTableContentJson@... Eduard Baciu

03:32 AM Bug #7473: rewrite toString() implementation for Dataset, StaticTempTable and TempTableBuilder to...

Rebased branch 7473a to trunk rev. 15208. Current revision at 15209. Andrei Iacob

05/14/2024

04:31 PM Bug #7473: rewrite toString() implementation for Dataset, StaticTempTable and TempTableBuilder to...

I have just notice that a branch 7473a already exists. It was not mentioned in the task so I assumed the changes are ... Ovidiu Maxiniuc

03:00 PM Bug #7473: rewrite toString() implementation for Dataset, StaticTempTable and TempTableBuilder to...

Review of code from #7473-12:
* the overall implementation is good. Nearly all of the notes below are either to incr... Ovidiu Maxiniuc

02:32 PM Bug #8769 (New): BIND argument passing for DATASET, TABLE, DATASET-HANDLE, TABLE-HANDLE arguments...

Constantin Asofiei

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

I've uploaded 1.48 to projsrv01 and upgraded the version in rev 15206.
I'll run ETF and test with another customer... Constantin Asofiei

01:52 PM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

I have reviewed the changes from 8593c/rev. 15205. Good job!
Is there a reason for downgrading the percentage done... Ovidiu Maxiniuc

09:33 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Committed 8593c/rev. 15205 assessing the review from Ovidiu. Alexandru Lungu

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

Constantin, please review 8593c_h2 changes. If they are OK, please upload it to the GCD repository.
Alexandru Lungu

05/13/2024

03:34 PM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Greg Shah wrote:
> Ovidiu/Eric: Please review 8593c.
I am OK with the code. A few of notes (cleanup/low priority)... Ovidiu Maxiniuc

03:10 PM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

These are the changes that unblocked me:... Alexandru Lungu

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

Alexandru, I don't like leaving 'allocated records' with no meaning in H2. Can we explicitly clear the primary key f... Constantin Asofiei

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

I am also having a hard time tracking down an issue with the truncate now (not related to my changes in 8593c/8593c_h... Alexandru Lungu

01:27 PM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

I committed 8593c_h2/rev. 50: Allowing forced reclaiming only for NO-UNDO tables. Otherwise, on a rollback, we may ha... Alexandru Lungu

12:15 PM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Eric, I am starting the review process in the next minutes. Please let me know if you are already in the process. Ovidiu Maxiniuc

09:50 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

I committed now 8593c/rev. 15204. This includes a requirement to use in-DB PK mapping if the table has normalized ext... Alexandru Lungu

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

Ovidiu/Eric: Please review 8593c.
This is quite Urgent since it is to resolve a regression in a customer applicati... Greg Shah

10:26 AM Feature #8756: Modifyable database comment string must support double quoted values

Modifyable database comment string must support double quoted values.
This is needed, because for example Label, Col... Tijs Wickardt

10:16 AM Feature #8756 (New): Modifyable database comment string must support double quoted values

Tijs Wickardt

04:34 AM Bug #7473: rewrite toString() implementation for Dataset, StaticTempTable and TempTableBuilder to...

Ovidiu, please provide a second review for the changes. Alexandru Lungu

05/12/2024

02:38 PM Bug #8593 (Review): H2 performance improvement for table 'truncate by multiplex'

Committed 8593c_h2/rev. 48 and 8593c/rev. 15203. Contains the following:
* H2 support for @NEXT PK FOR (<table-nam... Alexandru Lungu

05/08/2024

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

Constantin Asofiei wrote:
> This is a test where it gets into an infinite loop:
> [...]
>
> This can be expanded... Alexandru Lungu

09:56 AM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

This is a test where it gets into an infinite loop:... Constantin Asofiei

09:38 AM Bug #8593 (WIP): H2 performance improvement for table 'truncate by multiplex'

Timeline:
1. I was thinking of replacing the sequence based PK generator used by @FastCopyHelper@ with a more cust... Alexandru Lungu

05/02/2024

03:56 PM Bug #8593 (Test): H2 performance improvement for table 'truncate by multiplex'

Branch 8593b was merged to trunk rev 15189 and archived. Constantin Asofiei

03:33 PM Bug #8593 (Merge Pending): H2 performance improvement for table 'truncate by multiplex'

You can merge to trunk. Greg Shah

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

8593b passed ETF testing. Constantin Asofiei

01:49 PM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Code Review Task Branch 8593b.
I do not see anything wrong with the code (r15187-). Ovidiu Maxiniuc

12:47 PM Bug #8593: H2 performance improvement for table 'truncate by multiplex'

Code Review Task Branch 8593b Revision 15179
The @LowLevelSocketImpl@ changes look good.
Eric/Ovidiu: Please lo... Greg Shah

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

Created task branch 8593b from trunk rev 15186. Contains regression fixes (mixed):
* revno: 15190 - Fixed regressi... Constantin Asofiei