FWD » Core Development » Database

08/30/2023

09:39 AM Bug #7535 (Review): Temporary tables require trailing recid component even for unique indexes

Danut, I am mostly OK with the changes in 7535c.
* You call @if (!isUndoable()) { reclaimKeys();}@ Note that this ... Alexandru Lungu

08:09 AM Bug #7488: Slow fast-copy with before tables in H2

I applied the bullets from #7488-28 and committed to 7404a, rev. 14660. In addition to that, I also merged the two @p... Radu Apetrii

04:19 AM Bug #7488: Slow fast-copy with before tables in H2

Radu Apetrii wrote:
> The only relevant purpose at the moment for @isBefore@ would be bullet 2 from the list above. ... Alexandru Lungu

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

Alexandru Lungu wrote:
> * There is quite some logic around @isBefore@ inside @executeCopy@. Can you summarize it he... Radu Apetrii

05:12 AM Bug #7567: use Session.PK instead of DatabaseManager.PRIMARY_KEY wherever possible

*Committed 7567a/rev.14714 and 7567a_h2/rev.27*. Removed DatabaseManager.PRIMARY_KEY and replaced it's usage with Ses... Dănuț Filimon

04:31 AM Bug #7496 (Review): finish support for query:forward-only attribute

Danut, please let me know if there is something left in this task.
Please do a full round of testing with this:
*... Alexandru Lungu

04:00 AM Bug #7641: Lower the number of Map.get() calls in the persistence layer

Committed refactoring the code on 7641a revision 14715.
Eduard Soltan

08/29/2023

10:45 AM Bug #7488: Slow fast-copy with before tables in H2

*Review of 7404a*
* You don't actually need @FastCopyContext.newInstance@ - you can call the constructor directly.... Alexandru Lungu

06:57 AM Feature #7447 (Closed): Compare ValueString and ValueStringIgnoreCase faster in FWD-H2

Greg Shah

03:32 AM Feature #7447 (Review): Compare ValueString and ValueStringIgnoreCase faster in FWD-H2

Ok, this can be closed then - let me know if there is something left here to discuss Alexandru Lungu

03:29 AM Feature #7447: Compare ValueString and ValueStringIgnoreCase faster in FWD-H2

Great news! I retested the customer application using a different approach which allowed me to test it a lot faster a... Dănuț Filimon

08/28/2023

02:27 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

@ScriptRunner@ currently only accepts the commands:
* @udf.install@
* @udf.install.search_path@
It would need ... Eric Faulhaber

01:58 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

Ovidiu Maxiniuc wrote:
> I think the @build.xml@ is only modified to allow the packaging of the @ddl@ scripts inside... Roger Borrello

01:52 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

I think the @build.xml@ is only modified to allow the packaging of the @ddl@ scripts inside the app's jar file.
On... Ovidiu Maxiniuc

01:40 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

That is all understood... and @import.sh@ allows you to perform an import with only the @p2j.jar@, the @app.jar@ and ... Roger Borrello

01:04 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

Customers need to be able to deploy without a project installation. Optimally, the solution would only require the F... Greg Shah

12:02 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

If this tool cuts the muster, should it be part of FWD versus something given to the customers for use in their appli... Roger Borrello

10:24 AM Bug #7641: Lower the number of Map.get() calls in the persistence layer

Rebased 7641a to trunk. 14711. Alexandru Lungu

09:36 AM Feature #7447: Compare ValueString and ValueStringIgnoreCase faster in FWD-H2

Alexandru Lungu wrote:
> Danut, please check if this is still happening after your changes in #7454. Of course, befo... Dănuț Filimon

08:17 AM Bug #7488: Slow fast-copy with before tables in H2

Alexandru Lungu wrote:
> Radu Apetrii wrote:
> > The problem with this is that @TemporaryBuffer.copyAllRows@ is a *... Radu Apetrii

08:07 AM Bug #7488: Slow fast-copy with before tables in H2

Radu Apetrii wrote:
> The problem with this is that @TemporaryBuffer.copyAllRows@ is a *static* method, so I don't h... Alexandru Lungu

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

I've applied the suggestions from the last post (except one) and committed to 7404a, rev. 14658.
Alexandru Lungu w... Radu Apetrii

08:05 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

Alexandru Lungu wrote:
> Danut, please push on 7535c (newly created) a sound solution. Most important is to allow re... Dănuț Filimon

07:16 AM Feature #7064 (Rejected): Analyze the performance impact of the implicit meta schema in H2

Greg Shah

03:56 AM Feature #7064: Analyze the performance impact of the implicit meta schema in H2

* When you open a session and create a database, you reach @Database.open@, which calls @Database.addDatabaseObject@.... Alexandru Lungu

08/25/2023

10:46 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

> It is not completely clear to me what your conclusions are regarding persistent tables. I would like to avoid attem... Alexandru Lungu

10:20 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

Alexandru Lungu wrote:
> In the last 2 examples, in practice, there are other recids (1491 instead of 1488, etc.).... Eric Faulhaber

10:38 AM Bug #6941 (Rejected): conversion issue when using undo in do transaction

Greg Shah

10:31 AM Bug #6941 (WIP): conversion issue when using undo in do transaction

This can be closed / rejected. Alexandru Lungu

10:02 AM Bug #6941: conversion issue when using undo in do transaction

It seems that this has been solved in the meantime. I tested with trunk, rev. 14709 and everything worked fine. No is... Radu Apetrii

10:29 AM Bug #7641: Lower the number of Map.get() calls in the persistence layer

I am OK with most of the changes; there seemed to be quite some places which needed refactoring.
Eduard, please co... Alexandru Lungu

09:56 AM Bug #7496: finish support for query:forward-only attribute

*Committed 7496a/rev.14705*. After fixing #7737 (#7737-12) and investigating @TRANSACTION_COMMITTING@, I managed to f... Dănuț Filimon

06:36 AM Feature #4722: data import should be able to run with only the converted application jar file (an...

Roger Borrello wrote:
> I made some upgrades to the program to:
> # Handle multiple database imports
> # Retrieve ... Greg Shah

03:57 AM Bug #7488: Slow fast-copy with before tables in H2

*Review of 7404a, rev. 14656*
The changes are quite good now and look pretty stable. However, there are still some... Alexandru Lungu

08/24/2023

04:46 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

I made some upgrades to the program to:
# Handle multiple database imports
# Retrieve DDL from the application jar
... Roger Borrello

11:57 AM Feature #4722: data import should be able to run with only the converted application jar file (an...

I do notice that my application jar file does *not* include the ddl necessary to create the table structure. I can ea... Roger Borrello

08:27 AM Feature #7323: Implement soft unique index in FWD-H2

Committed 7323a_h2 as FWD-H2 rev. 26 and archived.
The FWD changes will be merged once we upgrade to the latest FW... Alexandru Lungu

03:18 AM Feature #7323: Implement soft unique index in FWD-H2

Alexandru Lungu wrote:
> Please focus on identifying any changes that may cause regressions when VALIDATE mode is no... Radu Apetrii

03:42 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

I was using @COMPILE test.p LISTING test.lst@ at some point, but this is informative only when working with a persist... Alexandru Lungu

08/23/2023

03:59 PM Bug #7535: Temporary tables require trailing recid component even for unique indexes

Constantin Asofiei wrote:
> Alexandru, you can use @COMPILE test.p LISTING test.lst@ to check the transaction behavi... Tijs Wickardt

10:23 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

Alexandru, you can use @COMPILE test.p LISTING test.lst@ to check the transaction behavior in 4GL. Keep in mind that... Constantin Asofiei

10:07 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

The test-cases you found are quite interesting. I've done some testing myself with nested transactions.
In 95% of... Alexandru Lungu

10:16 AM Feature #7064: Analyze the performance impact of the implicit meta schema in H2

Radu Apetrii wrote:
> Can/should this task be rejected? IMO, there is nothing left to investigate/implement here.
... Alexandru Lungu

09:16 AM Feature #7064: Analyze the performance impact of the implicit meta schema in H2

Can/should this task be rejected? IMO, there is nothing left to investigate/implement here. Radu Apetrii

08:42 AM Bug #7737: QueryWrapper should either show or throw errors depending on the query type

*Committed 7496a/rev.14704*. Fixed 4 errors in @QueryWrapper@.
I've created a test suite to test how errors are hand... Dănuț Filimon

07:13 AM Bug #7737: QueryWrapper should either show or throw errors depending on the query type

Danut, please fix the cases where errors behave different for static / dynamic queries. That is, change @QueryWrapper... Alexandru Lungu

07:07 AM Bug #7737: QueryWrapper should either show or throw errors depending on the query type

Alexandru Lungu wrote:
> Can you extend your testing for other kind of errors thrown by @QueryWrapper@? For instance... Dănuț Filimon

08:31 AM Feature #7404: Trasform replace-mode into append-mode when target table is empty

Radu Apetrii wrote:
> While testing something for #7488, I noticed a regression on a test with @copy-temp-table with... Radu Apetrii

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

I added some more changes to @FastCopyHelper@ on 7404a, rev. 14656:
* Merged the master/before methods, meaning that... Radu Apetrii

03:33 AM Bug #7403: Copy-temp-table with replace-mode should replace already inserted records

Radu, please note that fast-copy with REPLACE happens *only if* the destination is empty. This way, append is used in... Alexandru Lungu

03:06 AM Bug #7403: Copy-temp-table with replace-mode should replace already inserted records

Alexandru Lungu wrote:
> Radu, please check if this fixes your issue in #7404-32. After, please extract the changes ... Radu Apetrii

08/22/2023

07:13 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

OK... I see it isn't merged to trunk. What is left to do? I updated:... Roger Borrello

06:24 PM Feature #4722: data import should be able to run with only the converted application jar file (an...

Has this been merged to trunk yet? I have a new @import.sh@ script that should work with this usage:... Roger Borrello

09:34 AM Bug #7737: QueryWrapper should either show or throw errors depending on the query type

I see. It is weird that we don't have any similar use-case implemented in FWD: throw error if static, just show error... Alexandru Lungu

09:19 AM Bug #7737: QueryWrapper should either show or throw errors depending on the query type

Alexandru Lungu wrote:
> Is the fact that in the second example the query is scrolling?
It doesn't matter if the q... Dănuț Filimon

09:11 AM Bug #7737: QueryWrapper should either show or throw errors depending on the query type

Danut, can you attempt making the query forward-only *after* you prepare it, but *before* opening? Is there any diffe... Alexandru Lungu

09:08 AM Bug #7737 (WIP): QueryWrapper should either show or throw errors depending on the query type

Is the fact that in the second example the query is scrolling? Or maybe because the second query is dynamic? Or maybe... Alexandru Lungu

08:54 AM Bug #7737: QueryWrapper should either show or throw errors depending on the query type

Alexandru Lungu wrote:
> Is there a problem in changing @recordOrShowError@ into @recordOrThrowError@?
>
> Danut,... Dănuț Filimon

08:37 AM Bug #7737: QueryWrapper should either show or throw errors depending on the query type

Is there a problem in changing @recordOrShowError@ into @recordOrThrowError@?
Danut, do you have an example in whi... Alexandru Lungu

08:23 AM Bug #7737: QueryWrapper should either show or throw errors depending on the query type

Another simpler test:... Dănuț Filimon

08:14 AM Bug #7737: QueryWrapper should either show or throw errors depending on the query type

This test fails for *7496a/rev.14703* and *trunk/rev.14704*. ... Dănuț Filimon

07:51 AM Bug #7737 (Test): QueryWrapper should either show or throw errors depending on the query type

Dănuț Filimon

09:32 AM Bug #5452 (Closed): eliminate use of ResultSet.CONCUR_UPDATABLE?

Greg Shah

07:50 AM Bug #5452 (Test): eliminate use of ResultSet.CONCUR_UPDATABLE?

Branch 5452a was merged to trunk as rev 14704 and archived.
This can be closed. Alexandru Lungu

07:28 AM Bug #5452: eliminate use of ResultSet.CONCUR_UPDATABLE?

I am OK with the changes.
I also committed 5452a rev. 14563 removing @readOnly@ from share manager and multiplexer c... Alexandru Lungu

09:22 AM Bug #7412 (Closed): PresortQuery ORDER BY has to many clauses

Greg Shah

05:15 AM Bug #7412: PresortQuery ORDER BY has to many clauses

This can be closed. Alexandru Lungu

09:02 AM Bug #7489: Lazily initialize DMO signature

On a server start-up with 2251 DMO loaded, I got 40ms spent in quick signature building, 50ms spent in explicit signa... Alexandru Lungu

05:17 AM Feature #7404: Trasform replace-mode into append-mode when target table is empty

Radu, this task was mostly fixed, but it is still open for review. As you do a major refactoring of @FastCopyHelper@,... Alexandru Lungu

05:12 AM Feature #7320: Extend H2 tester from Hotel GUI

There are lots of insightful tests generated for FWD-H2 right from the H2 tester. However, these are unusable in FWD ... Alexandru Lungu

05:01 AM Bug #7403 (Review): Copy-temp-table with replace-mode should replace already inserted records

*I reviewed the changes in 7403a and they are OK.*
Radu, please check if this fixes your issue in #7404-32. After,... Alexandru Lungu

04:10 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

I retested after making a change to @Commitable@, but I am still left with two tests that end up in an infinite loop.... Dănuț Filimon

08/21/2023

02:09 PM Bug #7731: performance improvements for FQLPreprocessor

When something is inlined, the @FQLPreprocessor@ does not use the cache at all. What I noticed is that @FQLPreproces... Constantin Asofiei

02:03 PM Bug #7731 (Closed): performance improvements for FQLPreprocessor

Constantin Asofiei

10:01 AM Feature #7404: Trasform replace-mode into append-mode when target table is empty

While testing something for #7488, I noticed a regression on a test with @copy-temp-table with REPLACE@, introduced i... Radu Apetrii

08:01 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

Alexandru Lungu wrote:
> What about a 7535b?
Yes, please create 7535b so that I can start working on @Commitable@.
Dănuț Filimon

07:56 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

What about a 7535b? Alexandru Lungu

07:48 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

Alexandru Lungu wrote:
> Can you post the third example here to discuss why the recid is never reclaimed? Mayb is be... Dănuț Filimon

07:40 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

Dănuț Filimon wrote:
> I did 3 tests where records are deleted and then created in a loop (first test - no delete ob... Alexandru Lungu

07:36 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

Alexandru Lungu wrote:
> Create a dynamic buffer with @CREATE BUFFER buf@. Do similar work you've done in your tests... Dănuț Filimon

07:13 AM Feature #7323 (Review): Implement soft unique index in FWD-H2

Radu, I am planning to merge *7323a_h2* to FWD-H2. Please double check that everything is alright.
Please focus on... Alexandru Lungu

05:32 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2

Alexandru Lungu wrote:
> Note that the conversion *always* adds @UPPER@ for character fields because it is independe... Dănuț Filimon

05:20 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2

> This test case covers all the current problems with upper. The converted query looks like this:
Note that the co... Alexandru Lungu

05:16 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2

Alexandru Lungu wrote:
> Danut, please update [[internal-documentation:H2_Database_Fork]] with @DEFAULT_IGNORE_CASE@... Dănuț Filimon

04:45 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2

Dănuț Filimon wrote:
> @tt.f1 != "a"@ generates the expected @tt.f1 is null@ but without the @upper@ call. I am stil... Alexandru Lungu

03:59 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2

Alexandru Lungu wrote:
> Not really; @upper(tt.f1) is null@ is generated each time you do something like @tt.f1 != "... Dănuț Filimon

03:32 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2

*Committed 7454a_h2 to FWD_H2 trunk as rev. 25. Archived 7454a_h2.*
Danut, please update [[internal-documentation:... Alexandru Lungu

08/18/2023

10:53 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2

Dănuț Filimon wrote:
> upper(tt.f1) in ('A', 'B') and upper(tt.f1) is null look to be very specific.
Not really;... Alexandru Lungu

09:49 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2

Alexandru Lungu wrote:
> Danut, please let me know if there is anything left to be worked on this task. If everythin... Dănuț Filimon

09:39 AM Bug #7454 (Review): Make ValueStringIgnoreCase the default generated value for setString in FWD-H2

*Review of 7454a and 7454a_h2*
* I am OK with the changes.
* Regression tests passed.
* I am *no* longer hitting... Alexandru Lungu

04:15 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2

I've looked into the problem and @upper@ methods are not reintroduced later in @FQLPreprocessor.mainWalk()@. It was a... Dănuț Filimon

07:22 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

Dănuț Filimon wrote:
> Can you please elaborate?
Create a dynamic buffer with @CREATE BUFFER buf@. Do similar wor... Alexandru Lungu

06:48 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

Alexandru Lungu wrote:
> What happens to the other buffers (on other tables / other multiplex)? What if we iterate w... Dănuț Filimon

04:24 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

*Review of 7535a*
* Doing a reclaim on @iterate@ looks right. However, I think @iterate@ is called only for the bu... Alexandru Lungu

02:28 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

Eric Faulhaber wrote:
> I wouldn't expect @BY RECID DESC@ to work. That doesn't look like valid 4GL code.
>
> Tha... Dănuț Filimon

08/17/2023

12:09 PM Bug #7535: Temporary tables require trailing recid component even for unique indexes

Dănuț Filimon wrote:
> When running the @test01.i with tt01 BY RECID DESC@ test, I end up with this select statement... Eric Faulhaber

07:37 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

Alexandru Lungu wrote:
> Danut, can you paste here the testcase which causes the issue in #7535-35? Thank you.
The ... Dănuț Filimon

07:07 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

Danut, can you paste here the testcase which causes the issue in #7535-35? Thank you. Alexandru Lungu

04:20 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

I also found @CompoundQuery.cleaner@ which is also a @Finalizable@ instance, it's a similar situation to @PreselectQu... Dănuț Filimon

03:58 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

*Committed 7535a/rev.14673*. This is a necessary change that I mentioned in #7535-29 about the @PrelectQuery.cleaner@... Dănuț Filimon

03:46 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

Alexandru Lungu wrote:
> Danut, regarding the recid mismatch, please refer to #7647-2. Use Ovidiu's patch just to cl... Dănuț Filimon

03:23 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

> Currently I can't test this assumption because of an ongoing issue with jboss repository resource which stops the p... Alexandru Lungu

03:20 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

Danut, regarding the recid mismatch, please refer to #7647-2. Use Ovidiu's patch just to clear up *some* mismatches. ... Alexandru Lungu

11:15 AM Bug #7488: Slow fast-copy with before tables in H2

*Review of 7404a*
This is a good start, but it is still far from ideal at this point. Radu, please consider doing ... Alexandru Lungu

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

I've done some refactoring to @FastCopyHelper@:
* Added a cache that stores the instances of @FastCopyHelper@ based ... Radu Apetrii

09:42 AM Feature #7504: Export data tool from FWD into .d files

Another configuration option to consider is to allow a dump of only a subset of tables (perhaps an inclusive or exclu... Eric Faulhaber

08:21 AM Feature #7504: Export data tool from FWD into .d files

Greg Shah wrote:
> We might want to consider reading the configuration from the directory. In that case it will req... Alexandru Lungu

07:41 AM Feature #7504: Export data tool from FWD into .d files

Also I should point out that export will be used on production systems that won't have the standard application cfg p... Greg Shah

07:33 AM Feature #7504: Export data tool from FWD into .d files

We might want to consider reading the configuration from the directory. In that case it will require little or no pa... Greg Shah

07:19 AM Feature #7504: Export data tool from FWD into .d files

> Yes, any such utilities will often have some requirement for configuration. But we don't want them to be hard coded... Alexandru Lungu

07:11 AM Feature #7504: Export data tool from FWD into .d files

> Greg, by stored metadata dynamically you mean the beans we can find in the @dmo@ package (read annotations, hydrate... Greg Shah

06:49 AM Feature #7504: Export data tool from FWD into .d files

> I actually would like to move away from the current ant import.db and ImportWorker approach. These rely upon TRPL a... Alexandru Lungu

08:58 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2

Alexandru Lungu wrote:
> I still have a concern with indexOf function. It takes two strings as parameters. It attemp... Dănuț Filimon

06:51 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2

Regression tests passed.
Profiling tests shown -0.3% improvement (without temporary sequences). This is modest, but ... Alexandru Lungu

07:20 AM Bug #7496: finish support for query:forward-only attribute

*Committed 7496a/rev.14656*. I brought the changes made by Stefan in #7241 (7241b) to 7496a.
I've done tests with ... Dănuț Filimon

08/16/2023

06:52 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

When running the @test01.i with tt01 BY RECID DESC@ test, I end up with this select statement: ... Dănuț Filimon

03:44 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

I mentioned that keys are not reclaimed in simple @FOR EACH@ blocks and after making the necessary changes to reclaim... Dănuț Filimon

08/15/2023

03:45 AM Feature #7382: Check performance of delete from vs drop table in H2

Constantin Asofiei wrote:
> What I meant in FWD-H2 is to check if the number of selected records which are to be del... Dănuț Filimon

03:20 AM Bug #7641: Lower the number of Map.get() calls in the persistence layer

Made @fieldInfo@ a simple Java array, also added to @getMutableInfo@ a new parameter @fieldCount@, those meaning is n... Eduard Soltan

08/14/2023

02:46 AM Bug #7641: Lower the number of Map.get() calls in the persistence layer

Eduard, fieldInfo (and other structures related to fields) can be 'frozen' as a Java array once this table info was b... Constantin Asofiei

02:40 AM Feature #7382: Check performance of delete from vs drop table in H2

Alexandru, I didn't mean to change the DELETE SQL. What I meant in FWD-H2 is to check if the number of selected reco... Constantin Asofiei

08/11/2023

05:27 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

*Committed 7535a/rev.14672*. Applied the patch from #7535-26 after making another small change.
* Added reclaimKeys ... Dănuț Filimon

08/09/2023

04:56 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes

Using the patch posted in #7535-26, I've done similar tests to #7535-15 on 7535a using FWD-22 and all the previous pa... Dănuț Filimon

08/08/2023

08:39 AM Feature #7504: Export data tool from FWD into .d files

From Stefan via email:
> I created an ExportWorker class for #7504 and now I am trying to understand @ant import.d... Greg Shah

07:03 AM Bug #7667: Support OUTER-JOIN with PRESELECT at conversion

Andrei, please address #7667-2. Also, please make some tests with @CAN-FIND@ for that matter. Alexandru Lungu

05:32 AM Bug #7667: Support OUTER-JOIN with PRESELECT at conversion

Please note that the conversion of the @CompoundQuery@ to the @PreselectQuery@ should not be applied if one of the co... Igor Skornyakov

04:15 AM Bug #7667 (WIP): Support OUTER-JOIN with PRESELECT at conversion

This is a continuation of the #6196 effort of optimizing @CompoundQuery@ to merge components that have OUTER-JOIN. In... Alexandru Lungu

04:06 AM Bug #7667 (Test): Support OUTER-JOIN with PRESELECT at conversion

Alexandru Lungu

04:40 AM Feature #7323: Implement soft unique index in FWD-H2

I retested with the latest changes in 7323a and got -1% improvement now. This starts looking good. At this point I am... Alexandru Lungu

03:53 AM Bug #7496: finish support for query:forward-only attribute

There are a few things wrong with the patch from #7496-22 which I just found out while testing.
# TemporaryBuffer do... Dănuț Filimon

03:27 AM Bug #7496: finish support for query:forward-only attribute

Danut, please find a concrete example where 7496a (together with 7241b) is failing before @SessionListener.Event.TRAN... Alexandru Lungu

08/07/2023

10:12 AM Bug #7641: Lower the number of Map.get() calls in the persistence layer

Committed on 7641a revision 14683.
@fieldInfo@ in @AbstractTempTable@ became an @ArrayList@, instead of @HashMap@.... Eduard Soltan

04:01 AM Bug #7641: Lower the number of Map.get() calls in the persistence layer

Created 7641a. Alexandru Lungu

10:01 AM Bug #7496: finish support for query:forward-only attribute

I previously tested a large customer application using the changes from 7241b/rev.14655, 7496a/rev.14655 and a few ch... Dănuț Filimon

05:23 AM Bug #7334: Reclaim used sessions to improve performance

Session reclaiming couldn't be disabled since most values either default to a set value or only disable the managing ... Dănuț Filimon

08/04/2023

10:08 AM Bug #7641: Lower the number of Map.get() calls in the persistence layer

In @TempTableMapper@ there is a @private final Map<TempTable, LegacyTableInfo> p2j = new HashMap<>();@ which should b... Eduard Soltan

06:51 AM Feature #7382: Check performance of delete from vs drop table in H2

From Constantin's solution, I think we can just generate @delete from tt1@ when we know this as the last multiplex is... Alexandru Lungu

08/03/2023

08:05 AM Feature #7323: Implement soft unique index in FWD-H2

I've committed to 7323a, rev. 14690 and 7323a_h2, rev. 23. I added support for the @DirectAccess@ idea mentioned in #... Radu Apetrii

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

Alexandru Lungu wrote:
> *Radu, what is your input on this idea?*
I will investigate the aspects mentioned and I wi... Radu Apetrii

05:00 AM Feature #7323: Implement soft unique index in FWD-H2

I don't expect a miracle from @VALIDATE@, but 30k SELECT statements are in fact a lot (from my POV). I agree that the... Alexandru Lungu

04:28 AM Feature #7323: Implement soft unique index in FWD-H2

Alexandru Lungu wrote:
> Clearly we should see better improvement as now we have ~28k less SELECT statements, right?... Radu Apetrii

03:26 AM Bug #7488: Slow fast-copy with before tables in H2

Radu, there is some work in #7404 regarding the moving of most of the copy-temp-table operations to fast-copy using h... Alexandru Lungu

08/02/2023

04:19 AM Feature #7416: Reiterate DatabaseStatistics and leverage to other database profling tools

I have also created a script to analyze the following things:
* How many times each type of query was executed.
* W... Radu Apetrii

04:06 AM Feature #7416: Reiterate DatabaseStatistics and leverage to other database profling tools

I've added some changes to 7416b, rev. 14681. They include the following:
* Fixed the javadoc mentioned in #7416-23.... Radu Apetrii

08/01/2023

08:13 AM Feature #7365 (Closed): Avoid using reflection in generating BDT

Greg Shah

08:02 AM Feature #7365 (Test): Avoid using reflection in generating BDT

This was merged in trunk by 7026e and can be closed. Alexandru Lungu

08:02 AM Feature #7365 (Review): Avoid using reflection in generating BDT

Alexandru Lungu

04:55 AM Bug #7334 (WIP): Reclaim used sessions to improve performance

> Even though Session originally was intended to be used for a single connection check-out, should we be checking in ... Alexandru Lungu