Activity

From 07/31/2023 to 08/29/2023

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

07/31/2023

07:52 PM Feature #4722: data import should be able to run with only the converted application jar file (an...: After your requested update to my parameters, I have been able to make the connection and import... thank you for the... Roger Borrello
02:01 PM Bug #7647: Leverage internal H2 _ROWID_ with FWD recid: While working on first implementation of datasets I encountered an issue related to records from different temp-table... Ovidiu Maxiniuc
11:30 AM Bug #7647: Leverage internal H2 _ROWID_ with FWD recid: H2 is keeping an internal _rowid_ information for each row. For in-memory tables, this is basically the index at whic... Alexandru Lungu
11:15 AM Bug #7647 (New): Leverage internal H2 _ROWID_ with FWD recid: Alexandru Lungu
11:32 AM Bug #7334: Reclaim used sessions to improve performance: (In a different task) Alexandru Lungu wrote:
> > > Otherwise, there are 20 org.postgresql.jdbc.PgConnection, some ar... Eric Faulhaber
08:03 AM Bug #7641 (WIP): Lower the number of Map.get() calls in the persistence layer: Alexandru Lungu

« Previous

Also available in: Atom

Project

General

Profile

FWD » Core Development » Database

Activity

Activity

08/29/2023

08/28/2023

08/25/2023

08/24/2023

08/23/2023

08/22/2023

08/21/2023

08/18/2023

08/17/2023

08/16/2023

08/15/2023

08/14/2023

08/11/2023

08/09/2023

08/08/2023

08/07/2023

08/04/2023

08/03/2023

08/02/2023

08/01/2023

07/31/2023