Activity

From 06/29/2023 to 07/28/2023

07/29/2023

09:21 PM Bug #7645: Simplify _meta database initialization by removing <schema>.meta.xml resource: Currently, the population of schema related tables as part of the initialization of _meta database uses two sources:
... Ovidiu Maxiniuc
08:58 PM Bug #7645 (Test): Simplify _meta database initialization by removing <schema>.meta.xml resource: Ovidiu Maxiniuc

07/28/2023

03:22 PM Feature #7504: Export data tool from FWD into .d files: Greg Shah wrote:
> > The database can be spoiled with different kind of extra tables / fields we don't actually want... Ovidiu Maxiniuc
02:52 PM Feature #7504: Export data tool from FWD into .d files: I agree our ant build should have an option to use this, but I do want our utility code (Java) to be a complete stand... Greg Shah
07:51 AM Feature #7504: Export data tool from FWD into .d files: h3. Plan
We need an ant option for this. To be consistent, I suggest something like @ant export.db@ that relies on... Alexandru Lungu
11:14 AM Bug #7641: Lower the number of Map.get() calls in the persistence layer: From Constantin:
* *AbstractTempTable.getMutableInfo* - a plain array can be kept for cases when the @LegacyFieldI... Alexandru Lungu
11:12 AM Bug #7641 (Rejected): Lower the number of Map.get() calls in the persistence layer: Alexandru Lungu
10:23 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes: Keys should be reclaimed at the end of each iteration and when the block finishes, they should not be reclaimed too e... Dănuț Filimon
09:22 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes: Alexandru Lungu wrote:
> So what is the problem then? If @TemporaryBuffer.Context.commit@ is called:
> * is it call... Dănuț Filimon
08:37 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes: So what is the problem then? If @TemporaryBuffer.Context.commit@ is called:
* is it called at bad times? too late or... Alexandru Lungu
08:14 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes: Alexandru Lungu wrote:
> Note that @TemporaryBuffer.Context@ implements @Commitable@ and there is the whole reclaim ... Dănuț Filimon
07:57 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes: > TemporaryBuffer.commit() (method was commented) and RecordBuffer.rollback() (method was mostly commented)
Note t... Alexandru Lungu
07:35 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes: Alexandru Lungu wrote:
> *Please refactor the code in #7535-1 and identify where 2004 recid is reclaimed if there is... Dănuț Filimon
09:15 AM Bug #7567 (WIP): use Session.PK instead of DatabaseManager.PRIMARY_KEY wherever possible: Alexandru Lungu

07/27/2023

03:59 PM Feature #4722: data import should be able to run with only the converted application jar file (an...: Ovidiu, were you able to duplicate my issue at all? I still cannot get the script to work.
I have a very quick pro... Roger Borrello
09:16 AM Bug #7488: Slow fast-copy with before tables in H2: Do we really need the table names to be different at the database level? Why not reuse the same table and DMOs? It ... Greg Shah
09:03 AM Bug #7488: Slow fast-copy with before tables in H2: Greg Shah wrote:
> Perhaps they don't repeat because each time through a new dynamic tt is created (but it is really... Alexandru Lungu
08:21 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes: Danut, I don't think the changes are quite right. @autoCommit@ means:
* "yes": there is no active transaction (@do t... Alexandru Lungu

07/26/2023

10:10 AM Feature #7382: Check performance of delete from vs drop table in H2: There are cases where the temp-table is not really multiplexed across the FWD session - only one 'instance' of this t... Constantin Asofiei
09:28 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2: *Committed 7454a_h2/rev.30 and testcases/rev.2383*.
* Character literals were modified to be @ValueStringIgnoreCase... Dănuț Filimon
08:41 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2: Alexandru Lungu wrote:
> My point was to do a bit of refactoring on Functions to allow both IGNORECASE and CASESENSI... Dănuț Filimon
04:02 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2: My point was to do a bit of refactoring on Functions to allow both IGNORECASE and CASESENSITIVE as parameters for suc... Alexandru Lungu
03:44 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2: Alexandru Lungu wrote:
> Danut, the following statements contradict:
> * @the UPPER function that returns Value.STR... Dănuț Filimon
03:19 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2: Danut, the following statements contradict:
* @the UPPER function that returns Value.STRING_IGNORECASE;@: this theor... Alexandru Lungu
09:11 AM Bug #7488: Slow fast-copy with before tables in H2: I fixed the line longer than 110 characters and removed the invalidation block. I changed updatePeerRecords so now it... Ștefan Roman
08:10 AM Bug #7488: Slow fast-copy with before tables in H2: > the most consuming ones are between static tables and dynamic tables - and these don't quite repeat.
It is a com... Greg Shah
07:53 AM Bug #7488: Slow fast-copy with before tables in H2: Committed 7404a/rev. 14653. This resets the loose-copy flag if the loose property matching is the same as the same as... Alexandru Lungu
05:21 AM Bug #7488: Slow fast-copy with before tables in H2: Alexandru Lungu wrote:
> I will check next #7488-7: are there any copy operations that repeat (have the same source-... Alexandru Lungu
04:29 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes: Alexandru Lungu wrote:
> Lets make baby steps here. We need the recid reclaim be sound first. At that point, we shal... Dănuț Filimon
04:12 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes: Lets make baby steps here. We need the recid reclaim be sound first. At that point, we shall see how we can continue ... Alexandru Lungu
03:29 AM Bug #7421: Check only the indexes that were changed when using Validation.checkMaxIndexSize: I will redo the testing with *7421a/rev.14653* and @max-index-size@ set on 0. This will reduce the number of indexes ... Alexandru Lungu

07/25/2023

04:19 PM Feature #4722: data import should be able to run with only the converted application jar file (an...: The @registry.xml@ is not used with import. It may be opened as resource in common configuration, but its content is ... Ovidiu Maxiniuc
07:58 AM Feature #4722: data import should be able to run with only the converted application jar file (an...: Ovidiu Maxiniuc wrote:
> Roger, I used your jar and attempted to import a single table from your main database. It w... Roger Borrello
10:31 PM Feature #4722: data import should be able to run with only the converted application jar file (an...: Roger, I used your jar and attempted to import a single table from your main database. It works. The jar is good, pro... Ovidiu Maxiniuc
09:26 PM Feature #4722: data import should be able to run with only the converted application jar file (an...: Roger, could you put your @app.jar@ in a shared folder on devsrv01. I would like to attempt to debug against it, to u... Ovidiu Maxiniuc
09:33 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2: Found an interesting example when experimenting with functions in H2.
Here is a simple table definition: @create t... Dănuț Filimon
04:37 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2: Dănuț Filimon wrote:
> After testing a customer application, I noticed that there are instances of internal conversi... Alexandru Lungu
04:23 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2: I looked into #7454-16, the change to the @Parser@ works properly since it has access to the database settings.
Af... Dănuț Filimon
06:43 AM Bug #7488: Slow fast-copy with before tables in H2: Last minute notice: @updatePeerRecords@ doesn't use prepared statements, but generates plain SQL statements. *Stefan*... Alexandru Lungu
06:37 AM Bug #7488: Slow fast-copy with before tables in H2: |_. Simple copy |_. Append |_. Loose-copy |_. Extents |_. Before |_. Time |_. Count |_. Avg |_. Master Copy |_. Exten... Alexandru Lungu
04:15 AM Bug #7488: Slow fast-copy with before tables in H2: *Review of 7404a, revision 14652.*
* The lines you changed now exceed 110 characters. Consider extracting the last... Alexandru Lungu

07/24/2023

10:00 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2: Profiling shows -0.3% improvement. this is decent, but can be way better. I expect way more improvement after we get ... Alexandru Lungu
08:51 AM Bug #7454 (WIP): Make ValueStringIgnoreCase the default generated value for setString in FWD-H2: Great!
I've added in rev. 29 the possibility to make sequences temporary. I just noticed that there are several at... Alexandru Lungu
07:28 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2: Alexandru Lungu wrote:
> I found a regression while testing. I attempted a fix in 7454a_h2 / rev. 27. This has a wid... Dănuț Filimon
05:53 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2: Also, Danut, please make the flag naming consistent with the option. Right now, the option is @DEFAULT_IGNORE_CASE@ a... Alexandru Lungu
05:39 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2: I found a regression while testing. I attempted a fix in 7454a_h2 / rev. 27. This has a wide impact on direct-access,... Alexandru Lungu
09:21 AM Feature #7061 (Closed): Enable the use of lazy result sets in H2: Greg Shah
03:21 AM Feature #7061: Enable the use of lazy result sets in H2: This can be closed. Alexandru Lungu
09:06 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes: After investigating how the recid is reclaimed for temporary tables, I made a few changes to allow reclaiming only wh... Dănuț Filimon
06:52 AM Feature #6813: analyze and improve performance of dynamic conversion of temp-tables and queries: Eric Faulhaber wrote:
> What is left to do on this task? Can we update the % done to a value that reflects the true ... Constantin Asofiei
04:55 AM Feature #7323: Implement soft unique index in FWD-H2: I think the numbers are quite relevant, so I will write them here:
|_. JMX |_. Before |_. After |
| Total | 29.91... Alexandru Lungu
03:24 AM Feature #7504 (WIP): Export data tool from FWD into .d files: Alexandru Lungu

07/22/2023

08:09 AM Feature #4722: data import should be able to run with only the converted application jar file (an...: Ovidiu Maxiniuc wrote:
> To remove this, please add @data/standard.dict@ to your application jar. It is needed by dy... Roger Borrello
09:08 PM Feature #4722: data import should be able to run with only the converted application jar file (an...: 1. The log reports that @data/standard.dict@ could not be loaded as a resource from jar. Apparently, it was loaded fr... Ovidiu Maxiniuc
08:45 PM Bug #7421: Check only the indexes that were changed when using Validation.checkMaxIndexSize: Alexandru Lungu wrote:
> @checkMaxIndexSize@ is handling both SQL and 4GL limitations:
I know, I _might_ have writt... Ovidiu Maxiniuc

07/21/2023

06:42 PM Feature #4722: data import should be able to run with only the converted application jar file (an...: Ovidiu Maxiniuc wrote:
> Roger,
> I see a few issues with the @java@ statement:
Thanks... corrected, although I'm ... Roger Borrello
06:06 PM Feature #4722: data import should be able to run with only the converted application jar file (an...: Roger,
I see a few issues with the @java@ statement:
* you have a typo in @targetDb="postgresq"@ (final @l@ is miss... Ovidiu Maxiniuc
03:45 PM Feature #4722: data import should be able to run with only the converted application jar file (an...: I should note that I didn't convert the application with @4722@, I am just trying to use the @p2j.jar@. Let me know i... Roger Borrello
03:41 PM Feature #4722: data import should be able to run with only the converted application jar file (an...: I had success building the DB with this command:... Roger Borrello
12:32 PM Feature #7061: Enable the use of lazy result sets in H2: Since this has since been merged to trunk, can we close this issue now? Eric Faulhaber
12:30 PM Bug #7235 (Closed): Avoid selecting all fields for an CAN-FIND sub-select: Eric Faulhaber
10:52 AM Bug #7235: Avoid selecting all fields for an CAN-FIND sub-select: Yes. Alexandru Lungu
10:44 AM Bug #7235: Avoid selecting all fields for an CAN-FIND sub-select: Can this be closed? Eric Faulhaber
11:13 AM Feature #7323: Implement soft unique index in FWD-H2: I tested with the JMX and everything is fine. The number of inserts / cures and failed cures is the same, good job.
... Alexandru Lungu
10:51 AM Feature #7194 (Test): Avoid generating an ORDER-BY clause if not required: Eric Faulhaber wrote:
> What exactly does this mean? AFIACT, the changes have been integrated into FWD-H2, correct? ... Alexandru Lungu
10:42 AM Feature #7194: Avoid generating an ORDER-BY clause if not required: Alexandru Lungu wrote:
> I will move this to review/100% just because everything is done already - this last step ... Eric Faulhaber
10:49 AM Bug #7108 (Closed): Simulate upper/rtrim directly in H2 using case specific columns: Eric Faulhaber
10:36 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns: Yes Alexandru Lungu
10:35 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns: Can this be closed? Eric Faulhaber
10:38 AM Bug #7035 (Closed): Extract query parameters from statically converted FQL: Work on this task is complete for now, but based on the findings, we will not be integrating into trunk. Eric Faulhaber
10:30 AM Feature #6813: analyze and improve performance of dynamic conversion of temp-tables and queries: What is left to do on this task? Can we update the % done to a value that reflects the true status? Eric Faulhaber
08:58 AM Bug #7488: Slow fast-copy with before tables in H2: I added this first change. I tested with a small test and a client app and it works fine. Committed on 7404a, revisio... Ștefan Roman
07:24 AM Bug #7496: finish support for query:forward-only attribute: Alexandru Lungu wrote:
> Danut, please do your best to get this done asap. I intent to have it merged intro trunk by... Dănuț Filimon
04:47 AM Bug #7421: Check only the indexes that were changed when using Validation.checkMaxIndexSize: > I just noticed that neither MariaDbLenientDialect nor MariaDbDialect override the implementation of Dialect.getInde... Alexandru Lungu
04:37 AM Bug #7421: Check only the indexes that were changed when using Validation.checkMaxIndexSize: > Note that 4GL has variable size even for data types which have fixed known static sizes. For example, an int64 may ... Alexandru Lungu
04:03 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes: I think it is time for some digging :) As I said previously, lets start with the recid reclaiming process. Alexandru Lungu
03:53 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes: Alexandru Lungu wrote:
> The patch was targeting only temp database, so it was clear that @pt@ tests won't be improv... Dănuț Filimon
03:38 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes: The patch was targeting only temp database, so it was clear that @pt@ tests won't be improved. Anyway, this means the... Alexandru Lungu
03:31 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes: Alexandru Lungu wrote:
> Danut, can you extend the results from #7535-9 with the patch from #7373-35 (FWD-H2 1.22 an... Dănuț Filimon
02:43 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes: ... Alexandru Lungu
02:42 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes: Danut, can you extend the results from #7535-9 with the patch from #7373-35 (FWD-H2 1.22 and FWD-H2 1.24)? Alexandru Lungu
02:39 AM Bug #7185 (Test): H2 in-memory lazy hydration: I've got a +0.36% performance decrease, so the changes in 7185a can be dropped. At this point, the H2 modifications f... Alexandru Lungu

07/20/2023

03:13 PM Bug #7421: Check only the indexes that were changed when using Validation.checkMaxIndexSize: Dănuț Filimon wrote:
> @MariaDB@ enforces a limit of *3072* bytes.
> @PostgreSQL@ enforces a limit of *8191* bytes.... Ovidiu Maxiniuc
05:59 AM Bug #7421: Check only the indexes that were changed when using Validation.checkMaxIndexSize: At least for FWD-H2 we can skip the "check index size". In 4GL, temp-tables are subject to index size limitation, so ... Alexandru Lungu
05:21 AM Bug #7421: Check only the indexes that were changed when using Validation.checkMaxIndexSize: *Committed 7421a/rev.14653* Short-circuited indices when it is empty and removed redundant check on dirtyOffset. I al... Dănuț Filimon
02:51 AM Bug #7421: Check only the indexes that were changed when using Validation.checkMaxIndexSize: > I will do another profiling after this is completely optimized. Danut, please prepare of a full refactoring of chec... Alexandru Lungu
12:54 PM Feature #4722: data import should be able to run with only the converted application jar file (an...: I'd like to walk through the use of postgres Docker Official Image so as to discern any additional requirements for t... Roger Borrello
10:50 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes: I wonder how many of these tests fail due to "bad recid reclaim" vs "bad LAZY iteration" not considering recid. I sug... Alexandru Lungu
08:59 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes: Alexandru Lungu wrote:
> Danut, do you have any feedback on the change in #7535-3? According to your tests:
I test... Dănuț Filimon
03:08 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes: Danut, do you have any feedback on the change in #7535-3? According to your tests:
* Are there problems that occurs ... Alexandru Lungu
10:49 AM Bug #7496: finish support for query:forward-only attribute: Danut, please do your best to get this done asap. I intent to have it merged intro trunk by the end of this week, so ... Alexandru Lungu
10:01 AM Feature #7323: Implement soft unique index in FWD-H2: Alexandru Lungu wrote:
> Also, please make a JMX over 7323a (without any validate changes) to check the same things.... Radu Apetrii
06:54 AM Feature #7323: Implement soft unique index in FWD-H2: *Good news*: this also passes the full-regression tests I use. The only concern now is the time - I will start a prof... Alexandru Lungu
05:54 AM Feature #7323: Implement soft unique index in FWD-H2: Tested with 7323a/rev. 14595 with a simple POC application and got no regression. I am planning to use the JMX you pr... Alexandru Lungu
04:42 AM Feature #7323: Implement soft unique index in FWD-H2: I've refactored the logging process when handling a @SQLException@ in an INSERT/UPDATE. Instead of only checking the ... Radu Apetrii
08:16 AM Bug #7185: H2 in-memory lazy hydration: Rebased 7185a to latest trunk. Branch is now at rev. 14671.
Regression testing passes successfully.
Started profili... Alexandru Lungu
06:03 AM Feature #4514: run ProDataSet test suite in FWD and resolve any issues such that it works the sam...: I have merged the testcases 4514a branch repo revisions 1454 to 1456 into the testcases repo bzr+ssh://xfer.goldencod... Maciej Zieniuk

07/19/2023

04:23 PM Feature #4514: run ProDataSet test suite in FWD and resolve any issues such that it works the sam...: Some additional context on the testcases 4514a repo, all revisions (1454 to 1456) are safe to put into testcases repo... Maciej Zieniuk
03:43 PM Feature #4514: run ProDataSet test suite in FWD and resolve any issues such that it works the sam...: I lot have changed in fwd trunk and testcaseses repos since i last worked on this, some of my comments may be inacurr... Maciej Zieniuk
02:56 PM Bug #7421: Check only the indexes that were changed when using Validation.checkMaxIndexSize: AFAIR, we are always doing the "legacy" max index size check (i.e., the one that enforces a Progress database limit),... Eric Faulhaber
11:33 AM Bug #7421 (WIP): Check only the indexes that were changed when using Validation.checkMaxIndexSize: *Good news*: Testing shows no regression. Profiling shows some improvement, currently -0.8%. However, I am not quite ... Alexandru Lungu
12:25 PM Feature #4722: data import should be able to run with only the converted application jar file (an...: OK, I will investigate how the @ScriptRunner@ can be exactly used to run those scripts. Ovidiu Maxiniuc
11:46 AM Feature #4722: data import should be able to run with only the converted application jar file (an...: We should not have to place anything in the file system including @ddl/@. Let's work toward everything coming from t... Greg Shah
11:37 AM Feature #4722: data import should be able to run with only the converted application jar file (an...: I was talking only about the import, with the database created and schema installed.
The file local @ddl/@ (this i... Ovidiu Maxiniuc
11:24 AM Feature #4722: data import should be able to run with only the converted application jar file (an...: Ovidiu Maxiniuc wrote:
> ... in a directory which lacked all other conversion artifacts, except: application, p2j an... Constantin Asofiei
11:22 AM Feature #4722: data import should be able to run with only the converted application jar file (an...: The problem comes from the fact that the paths for .df file is configurable (for each namespace independently). The c... Ovidiu Maxiniuc
10:26 AM Feature #4722: data import should be able to run with only the converted application jar file (an...: I see little reason to work from the file system instead of the jar. Any processing from the jar, should be highly s... Greg Shah
10:46 AM Bug #7496: finish support for query:forward-only attribute: That is great - please ensure that #7496-18 still holds after refactoring. Also, do some skim debugging on more compl... Alexandru Lungu
09:48 AM Bug #7496: finish support for query:forward-only attribute: Alexandru Lungu wrote:
> Danut, please check what happens if you actually do @first@, @prev@ or @last@ when type-for... Dănuț Filimon
07:08 AM Bug #7496: finish support for query:forward-only attribute: Danut, please check what happens if you actually do @first@, @prev@ or @last@ when type-forward only is set (in 4GL a... Alexandru Lungu
07:07 AM Feature #7323: Implement soft unique index in FWD-H2: I've analyzed the problem a bit and it seems that those @Unique index or primary key violation@ appear because the fi... Radu Apetrii

07/18/2023

04:42 PM Bug #7474: FindQuery provides the wrong result because the record is not updated in the database: I also had some thoughts on performance. Ideally, we should delay the flush as long as possible, as long as the queri... Ovidiu Maxiniuc
02:20 AM Bug #7474: FindQuery provides the wrong result because the record is not updated in the database: Ovidiu Maxiniuc wrote:
> Isn't this the same issue as #7373?
>
> As noted in my #7373-35 the problem can apparent... Alexandru Lungu
04:30 PM Feature #4722: data import should be able to run with only the converted application jar file (an...: Greg Shah wrote:
> Ovidiu: Is there anything else needed?
Roger raised the problem of some kind of defaulting fro... Ovidiu Maxiniuc
04:04 PM Feature #4722 (Review): data import should be able to run with only the converted application jar...: Eric: Please review.
Ovidiu: Is there anything else needed? Greg Shah
04:01 PM Feature #4722: data import should be able to run with only the converted application jar file (an...: Branch 4722a should help you do just that. It adds the @import.xml@ script to @p2j.jar@ and allows additional files t... Ovidiu Maxiniuc
09:10 AM Feature #4722: data import should be able to run with only the converted application jar file (an...: What do I need to do for the data import to work with all the artifacts in the .jar files, so they are read from the ... Constantin Asofiei
02:18 PM Bug #7388 (Test): Create server configuration container for cache sizes: Greg Shah
10:39 AM Bug #7421: Check only the indexes that were changed when using Validation.checkMaxIndexSize: I am OK with the changes in 7421a/rev.14652.
Planning to test and profile them asap. Alexandru Lungu
10:17 AM Bug #7488: Slow fast-copy with before tables in H2: Well, there are some bits of code using strings. Even the signature match does some string comparisons. The SQL compo... Alexandru Lungu
08:45 AM Bug #7488: Slow fast-copy with before tables in H2: Isn't there some string comparison overhead in calculating the field name mappings? Greg Shah
08:18 AM Bug #7488: Slow fast-copy with before tables in H2: > do you mean if we reuse the copying plan across copy-temp-table statements? So if two tables are part of a copy pro... Greg Shah
08:05 AM Bug #7488: Slow fast-copy with before tables in H2: I like the "copying plan" terminology :) This is accurate. We keep a database level mapping on the keys (source to de... Alexandru Lungu
07:54 AM Bug #7488: Slow fast-copy with before tables in H2: When we copy between any 2 given DMOs, do we save and reuse all the work we do to figure out the "copying plan"? Greg Shah
07:23 AM Bug #7488: Slow fast-copy with before tables in H2: Alright; please go ahead with a commit in this sense to 7404a Alexandru Lungu
03:44 AM Bug #7488: Slow fast-copy with before tables in H2: After some investigations, @FastCopyHelper.updatePeerRecords@ is not exactly the bottle-neck. When using fast-copy wi... Ștefan Roman
09:03 AM Feature #7323: Implement soft unique index in FWD-H2: Radu, this is something that triggered the error, but note that the code is only a cut-down, so you will need to set ... Alexandru Lungu
04:52 AM Feature #7323: Implement soft unique index in FWD-H2: Alexandru Lungu wrote:
> I will do my best to attempt extracting a test-case for you, but I can't guarantee I can ge... Radu Apetrii
08:22 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes: Alexandru Lungu wrote:
> Danut, please make a full test suite with text output with temp tables and persistent table... Dănuț Filimon
03:30 AM Bug #7496: finish support for query:forward-only attribute: *Review of 7496a*
* I don't think @setScrolling@ should be called when calling @setForwardOnly@. This will make al... Alexandru Lungu

07/17/2023

03:04 PM Bug #7535: Temporary tables require trailing recid component even for unique indexes: In fact, I was thinking first of 4GL side, to see whether strange issues occur. Ovidiu Maxiniuc
12:26 PM Bug #7467 (Test): join on meta table: 7467a was merged into trunk as r14658. The branch was archived. Ovidiu Maxiniuc
11:21 AM Bug #7467: join on meta table: Please go ahead with the merge, after 6976a. Greg Shah
10:51 AM Bug #7467: join on meta table: Eric Faulhaber wrote:
> Is there any reason to keep this task in review status, if these regressions are not related... Constantin Asofiei
02:25 AM Bug #7467: join on meta table: Constantin Asofiei wrote:
> Ovidiu Maxiniuc wrote:
> > Constantin, is it OK for you to run a quick ETF test on this... Eric Faulhaber
10:21 AM Bug #7474: FindQuery provides the wrong result because the record is not updated in the database: Isn't this the same issue as #7373?
As noted in my #7373-35 the problem can apparently (it did for that testcase, ... Ovidiu Maxiniuc
03:21 AM Bug #7474: FindQuery provides the wrong result because the record is not updated in the database: I feel this vulnerability we have here is quite concerning as it might generate inconsistent data from @_temp@. There... Alexandru Lungu
10:07 AM Bug #7496: finish support for query:forward-only attribute: Alexandru Lungu wrote:
> I think that we can't rely on @QueryWrapper@ to properly do the propagation in the delegate... Dănuț Filimon
05:44 AM Bug #7496 (WIP): finish support for query:forward-only attribute: Danut, I think the following code is quite interesting:... Alexandru Lungu
04:58 AM Bug #7496: finish support for query:forward-only attribute: *Committed 7496a/rev.14653*. Quick changes made based on the #7496-12 review. Similar to @PreselectQuery@, I removed ... Dănuț Filimon
04:33 AM Bug #7496 (Review): finish support for query:forward-only attribute: *Review of 7496a*
* We still need support for @forwardOnly@ in lazy @AdaptiveQuery@. Therefore, it is fine to exec... Alexandru Lungu
08:43 AM Bug #7567: use Session.PK instead of DatabaseManager.PRIMARY_KEY wherever possible: This should also be extended to FWD-H2 direct-access, as it presumes that the primary key column is always named @rec... Alexandru Lungu
02:38 AM Bug #7567: use Session.PK instead of DatabaseManager.PRIMARY_KEY wherever possible: @Session.PK@ was introduced during our ORM refactoring (when we removed Hibernate from FWD), to represent the configu... Eric Faulhaber
02:27 AM Bug #7567 (WIP): use Session.PK instead of DatabaseManager.PRIMARY_KEY wherever possible: Eric Faulhaber
07:57 AM Feature #7323: Implement soft unique index in FWD-H2: Radu, I tested 7323a and I still have @Unique index or primary key violation@ (lots). I've debugged a bit and I've se... Alexandru Lungu
04:22 AM Feature #7416: Reiterate DatabaseStatistics and leverage to other database profling tools: Radu, I just encountered the following in @Persistence@:... Alexandru Lungu

07/16/2023

10:25 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes: Ovidiu Maxiniuc wrote:
> A similar 2nd case: keep the index, but force a specific BY sorting so that the index _cann... Alexandru Lungu

07/15/2023

09:10 PM Bug #7535: Temporary tables require trailing recid component even for unique indexes: Alexandru Lungu wrote:
> *Ovidiu*, I am not quite sure what this means. Do you mean testing explicit @BY@ clauses to... Ovidiu Maxiniuc

07/14/2023

09:32 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2: Before talking about the results of the performance tests, here is a list of short terms that I will use and their me... Dănuț Filimon
07:15 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2: *Committed 7454a_h2/rev.26*. I added the missing test file and fixed the condition in Query as specified in #7454-10.... Dănuț Filimon
03:22 AM Bug #7535: Temporary tables require trailing recid component even for unique indexes: > * the unicity of the index, as you mentioned;
In non-unique indexes, we already append a trailing @recid@. We ca... Alexandru Lungu
09:42 PM Bug #7535: Temporary tables require trailing recid component even for unique indexes: Very good observation. This is an edge-case scenario we (or at least I) never encountered before. There are a lot of ... Ovidiu Maxiniuc

07/13/2023

09:11 AM Bug #7496: finish support for query:forward-only attribute: I didn't find any problem while testing a customer application.
*Committed testcases/rev.2380*. Added @FORWARD-ONL... Dănuț Filimon
07:49 AM Bug #7496: finish support for query:forward-only attribute: I did a few tests with browse and found a few problems:
* Between 7421a/rev.14649 and 7421a/rev.14651, the following... Dănuț Filimon
09:02 AM Bug #7420 (Review): Optimize Cursor for scrolling AdaptiveQuery: 7026e reached into trunk. This can be closed.
I couldn't replicate my times from #7420. I guess the tracing was spoi... Alexandru Lungu
08:59 AM Bug #7334 (Test): Reclaim used sessions to improve performance: This reached trunk and can be closed. Alexandru Lungu
06:10 AM Bug #7535 (WIP): Temporary tables require trailing recid component even for unique indexes: My investigation for #7474 and #7455 lead me to the following:... Alexandru Lungu
06:06 AM Bug #7535 (Test): Temporary tables require trailing recid component even for unique indexes: Alexandru Lungu
03:27 AM Bug #7421: Check only the indexes that were changed when using Validation.checkMaxIndexSize: *Committed 7421a/rev.14652*. Added the changes mentioned in #7421-10.
Alexandru Lungu wrote:
> Review of 7421a
> *... Dănuț Filimon

07/12/2023

01:28 PM Bug #7467: join on meta table: Ovidiu Maxiniuc wrote:
> Constantin, is it OK for you to run a quick ETF test on this? Conversion is not mandatory, ... Constantin Asofiei
10:51 AM Bug #7474 (WIP): FindQuery provides the wrong result because the record is not updated in the dat...: I tried several things to fix this, but without any obvious success; I still need time for some attempts. There is a ... Alexandru Lungu
07:51 AM Bug #7496: finish support for query:forward-only attribute: Alexandru Lungu wrote:
> Ok! Danut please take the extra mile to ensure that @ResultSet.FORWARD_ONLY@ is used if @qu... Dănuț Filimon
02:55 AM Bug #7496: finish support for query:forward-only attribute: Ok! Danut please take the extra mile to ensure that @ResultSet.FORWARD_ONLY@ is used if @query:forward-only@ is set. ... Alexandru Lungu
07:20 AM Bug #7421: Check only the indexes that were changed when using Validation.checkMaxIndexSize: *Review of 7421a*
* I am OK with the changes. Well done!
* The only point left here is in @BaseRecord.getDirtyFie... Alexandru Lungu

07/11/2023

05:02 PM Bug #7467: join on meta table: If a relation is not detected at conversion time or if the annotation was removed, the persistence will always attemp... Ovidiu Maxiniuc
09:59 AM Bug #7496: finish support for query:forward-only attribute: Alexandru Lungu wrote:
> Danut, please double check 4GL if it actually remembers that the query was scrolling in the... Dănuț Filimon
09:53 AM Bug #7496: finish support for query:forward-only attribute: > The documentation says that the forward-only attribute can't be set while a query is open or is being browsed. In t... Alexandru Lungu
09:42 AM Bug #7496: finish support for query:forward-only attribute: *Committed 7496a/rev.14650*. Reposition can be done only for non-scrolling queries. From the test suite I noticed tha... Dănuț Filimon
05:22 AM Bug #7496: finish support for query:forward-only attribute: I did not found any tests that use @forward-only@ so I created a test suite with 12 examples. From the 12 tests menti... Dănuț Filimon
03:13 AM Bug #7496 (WIP): finish support for query:forward-only attribute: Danut, please focus on this issue. Check if we already have some tests for @query:forward-only@. Otherwise, build a f... Alexandru Lungu
08:59 AM Feature #7504: Export data tool from FWD into .d files: This is a task inspired by #7241: the need of exporting the data from FWD in .d files to do a schema upgrade on impor... Alexandru Lungu
08:55 AM Feature #7504 (Test): Export data tool from FWD into .d files: Alexandru Lungu
02:50 AM Bug #7352 (WIP): Mismatching results when comparing case-insensitive/case-sensitive values betwee...: Eduard Soltan

07/10/2023

06:47 PM Bug #7496: finish support for query:forward-only attribute: Legacy support for this attribute was added long ago, but it seems FWD does nothing internally with the information, ... Eric Faulhaber
06:12 PM Bug #7496 (Test): finish support for query:forward-only attribute: Eric Faulhaber
09:48 AM Bug #7467: join on meta table: What about relations which do get saved at the DMO interface? Are these mandatory for the @FIND ... OF ... @ to work... Constantin Asofiei
08:55 AM Bug #7421: Check only the indexes that were changed when using Validation.checkMaxIndexSize: I tested a large customer application for ~45 minutes and managed to extract a total of *907392* statements, here's a... Dănuț Filimon
06:42 AM Bug #7421: Check only the indexes that were changed when using Validation.checkMaxIndexSize: Dănuț Filimon wrote:
> I committed 7421a/rev.14627 which fixes this mistake.
7421a was rebased with trunk/rev.14649... Dănuț Filimon
04:57 AM Bug #7421: Check only the indexes that were changed when using Validation.checkMaxIndexSize: Alexandru Lungu wrote:
> Danut, what do you mean by single index. I read your statement, but I don't understand what... Dănuț Filimon
07:18 AM Bug #6834 (WIP): RAQ navigation on records having NULL values on same index components: Alexandru Lungu
07:17 AM Bug #7167 (WIP): Associating records from opened buffers to new sessions is slow: This is basically fixed by the reclaimable session Danut implemented recently in #7334. This is in trunk now. Alexandru Lungu
07:16 AM Bug #7367 (Closed): disable TriggerTracker for TemporaryBuffer: Greg Shah
07:16 AM Bug #7367: disable TriggerTracker for TemporaryBuffer: This can be closed. Alexandru Lungu
05:21 AM Bug #7334: Reclaim used sessions to improve performance: - moved to #7425 - Alexandru Lungu
03:52 AM Bug #7334: Reclaim used sessions to improve performance: I updated [[p2j:Database_Configuration#Persistence|Database Configuration]] with the configuration and explanation fo... Dănuț Filimon
05:13 AM Feature #7404: Trasform replace-mode into append-mode when target table is empty: I added a break-down analysis of each operation done by fast-copy in #7404-19. Therefore, note that the cumulative ti... Alexandru Lungu
02:01 AM Bug #7489: Lazily initialize DMO signature: Please delay the work here until I do some metrics on how much time is spent on creating this signatures first. This ... Alexandru Lungu

07/07/2023

10:21 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2: *Review*
* In @Query@, the comparison is not correct. If @a@ and @b@ don't have the same value type, it doesn't m... Alexandru Lungu
06:48 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2: *Committed 7454a_h2/rev.25*.
* Renamed @OPTIMIZE_IGNORE_CASE@ to @DEFAULT_IGNORE_CASE@
* Fixed test cases to handle... Dănuț Filimon
05:57 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2: The problem mentioned in #7454-7 is almost solved, all there is to do is to test it a bit more, I even managed to wri... Dănuț Filimon
08:31 AM Bug #7334: Reclaim used sessions to improve performance: Merged 7334a to trunk as rev. 14645. Archived 7334a. Alexandru Lungu
07:31 AM Bug #7334: Reclaim used sessions to improve performance: Alexandru Lungu wrote:
> Rebased 7334a with trunk rev. 14642. 7334a is now at rev. 14647.
>
> Danut, please updat... Dănuț Filimon
06:41 AM Bug #7334: Reclaim used sessions to improve performance: The time improvement is -2.5%.
I've done two heap dumps and compared them. I have the same number of instances wit... Alexandru Lungu
04:09 AM Bug #7334: Reclaim used sessions to improve performance: Rebased 7334a with trunk rev. 14642. 7334a is now at rev. 14647.
Danut, please update 7334a and try to do a full t... Alexandru Lungu
06:16 AM Feature #7404: Trasform replace-mode into append-mode when target table is empty: Rebased 7404a to latest trunk. 7404a is now at rev. 14651. Alexandru Lungu
03:17 AM Feature #7404: Trasform replace-mode into append-mode when target table is empty: Stefan, please add these two sub-tasks (#7489 and #7488) to the H2 performance Wiki asap. Alexandru Lungu
03:14 AM Feature #7404: Trasform replace-mode into append-mode when target table is empty: The current performance degraded even more to +0.6%. This may be due to the slow fast-copy we do. I guess most of the... Alexandru Lungu
04:10 AM Feature #7416: Reiterate DatabaseStatistics and leverage to other database profling tools: Radu, I have the following warning when building:... Alexandru Lungu
09:05 PM Bug #7467: join on meta table: Unlike the other two join relations, this is not saved to DMO interface. The runtime code which analyses the involved... Ovidiu Maxiniuc

07/06/2023

09:45 AM Bug #7403: Copy-temp-table with replace-mode should replace already inserted records: I tried integrating the invalidation with other occurrences of @invalidateFFCache@ but I couldn`t find a proper way, ... Ștefan Roman
09:35 AM Bug #7489: Lazily initialize DMO signature: If there is a benefit to lazily computing them, then there is a benefit to compute them in advance. Of course, there... Greg Shah
08:54 AM Bug #7489: Lazily initialize DMO signature: Do you think of any performance gain if we compute them at conversion time? The static DMOs will have their signature... Alexandru Lungu
08:46 AM Bug #7489: Lazily initialize DMO signature: Can these signatures be computed at conversion time? If so, let's compute them once and write them into the DMO as @... Greg Shah
08:39 AM Bug #7489 (WIP): Lazily initialize DMO signature: DmoSignature is eagerly computed in the @DmoMeta@ constructor. This may not be ideal for dynamic temp-tables that won... Alexandru Lungu
08:36 AM Bug #7489 (Rejected): Lazily initialize DMO signature: Alexandru Lungu
09:22 AM Bug #7388 (Review): Create server configuration container for cache sizes: Merged 7388a in trunk as rev. 14641 and archived. Alexandru Lungu
08:42 AM Bug #7467: join on meta table: Ovidiu, is the relation info added at the DMOs during conversion mandatory for the runtime to work properly? I ask be... Constantin Asofiei
09:34 PM Bug #7467: join on meta table: Eric Faulhaber wrote:
> Code review 7467a/14636:
>
> Sorry, it's been a long time since I looked at this code and... Ovidiu Maxiniuc
08:40 AM Feature #7404: Trasform replace-mode into append-mode when target table is empty: Created #7448 and #7449 to further optimize the temp-table (fast-)copy process. Alexandru Lungu
07:24 AM Bug #7334: Reclaim used sessions to improve performance: Alexandru Lungu wrote:
> *Constantin, if there are other topics to be discussed here, please let me know. I will alw... Constantin Asofiei
07:01 AM Bug #7334: Reclaim used sessions to improve performance: Alexandru Lungu wrote:
> Danut, just to confirm:
> * If I don't set any option, there will be no reclaim.
> * If I... Dănuț Filimon
06:31 AM Bug #7334 (Review): Reclaim used sessions to improve performance: I will redo the testing and performance with this latest version (7334a / rev.14641). I intend to rebase and merge 73... Alexandru Lungu
06:23 AM Bug #7488 (WIP): Slow fast-copy with before tables in H2: This is mostly related to #7404-19. After several optimizations, the most time consuming operations of fast-copy are ... Alexandru Lungu
06:21 AM Bug #7488 (Closed): Slow fast-copy with before tables in H2: Alexandru Lungu

07/05/2023

06:31 PM Bug #7467: join on meta table: Code review 7467a/14636:
Sorry, it's been a long time since I looked at this code and it has changed quite a lot f... Eric Faulhaber
03:13 PM Bug #7467: join on meta table: Constantin Asofiei wrote:
> Ovidiu, we need this in trunk soon. What testing is needed?
The conversion does not ac... Ovidiu Maxiniuc
01:16 PM Bug #7467: join on meta table: Ovidiu, we need this in trunk soon. What testing is needed?
Also, do you still see the @com.goldencode.p2j.schema... Constantin Asofiei
11:22 AM Bug #7449: unqualified _File buffer must target the first database in the connection list: Eric Faulhaber wrote:
> Constantin Asofiei wrote:
> > Eric, is it OK to ensure that for the @standard@ namespace by... Constantin Asofiei
10:56 AM Bug #7449: unqualified _File buffer must target the first database in the connection list: Constantin Asofiei wrote:
> Eric, is it OK to ensure that for the @standard@ namespace by default the @SchemaConfig$... Eric Faulhaber
10:18 AM Bug #7449: unqualified _File buffer must target the first database in the connection list: There is an unintended consequence to these changes. If in @p2j.cfg.xml@, the @standard@ namespace is not explicitly... Constantin Asofiei
10:57 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2: I looked into the rtrim test and the failed assertion was caused by something that should've been expected. If you cr... Dănuț Filimon
09:59 AM Bug #7448: Optimize FWD-H2 ValueTimestampTimeZone and maybe avoid caching: I made another test that calculates the avg @ValueTimestampTimeZone@ that are in cache. I`m checking every 1000 Value... Ștefan Roman
07:55 AM Bug #7448: Optimize FWD-H2 ValueTimestampTimeZone and maybe avoid caching: I added a test for the number of @CurrentTimestamp.get@ and the time spent doing it. I will attach a patch so you can... Ștefan Roman
08:31 AM Feature #7404: Trasform replace-mode into append-mode when target table is empty: I added the first change, where I retrieve sqlSignature only if simpleCopy is false, I will wait for another profilin... Ștefan Roman
07:33 AM Feature #7404: Trasform replace-mode into append-mode when target table is empty: I tested with a large application and I got some interesting insights:
|_. Simple copy |_. Append |_. Loose-copy |... Alexandru Lungu
04:36 AM Feature #7404: Trasform replace-mode into append-mode when target table is empty: I done some testing and everything works fine. I only notices a slight improvement:
* The usual case is to match t... Alexandru Lungu
07:28 AM Bug #7334: Reclaim used sessions to improve performance: I managed to finish and test @Session@ and @DmoVersioning@, I especially looked into @Session.cache@, @Session.cacheE... Dănuț Filimon
04:39 AM Feature #6815: configure all cache sizes in the directory, and create documentation for them: Alexandru Lungu wrote:
> This is already implemented in 7388a.
We need also the documentation. Constantin Asofiei
03:29 AM Feature #6815: configure all cache sizes in the directory, and create documentation for them: This is already implemented in 7388a. Alexandru Lungu
03:34 AM Feature #7447 (WIP): Compare ValueString and ValueStringIgnoreCase faster in FWD-H2: Danut, please check if this is still happening after your changes in #7454. Of course, before the changes, there were... Alexandru Lungu
03:30 AM Bug #6385 (WIP): Problem with conversion of REPOSITION TO ROWID with UNKNOWN literal for rowid: Alexandru Lungu

07/04/2023

09:27 AM Bug #7474: FindQuery provides the wrong result because the record is not updated in the database: To narrow down the example, the main point here is that a different buffer is used for the record that gets updated. ... Radu Apetrii
08:43 AM Feature #7404 (Review): Trasform replace-mode into append-mode when target table is empty: Review to *7404a, revision 14631*
* The changes are OK, good job.
I will do a testing + profiling round. Keep y... Alexandru Lungu
07:46 AM Feature #7404: Trasform replace-mode into append-mode when target table is empty: The problem was that the tables created dynamically had changed field names in SQL (field1, field2, ...) and the @exp... Ștefan Roman
07:48 AM Bug #7448 (WIP): Optimize FWD-H2 ValueTimestampTimeZone and maybe avoid caching: Stefan, this is a performance concern; please focus on fixing this. Alexandru Lungu
07:47 AM Bug #7412 (Test): PresortQuery ORDER BY has to many clauses: 7026e reached trunk as rev. 14638.
This can be closed now. Alexandru Lungu
07:24 AM Feature #7323: Implement soft unique index in FWD-H2: Alexandru Lungu wrote:
> Cool! I am waiting for the regression fix now, so at that point I am able to do the proper ... Radu Apetrii
05:20 AM Feature #7323: Implement soft unique index in FWD-H2: > I've allowed them to still do the insert/update, but I've decided to not log the cases in which the database can't ... Alexandru Lungu
05:09 AM Feature #7323: Implement soft unique index in FWD-H2: Here's a patch for measuring how many inserts/updates are executed in total/successfully with @VALIDATE@ and seeing h... Radu Apetrii
04:23 AM Feature #7323: Implement soft unique index in FWD-H2: I've committed to 7323a, rev. 14591 the following changes:
Alexandru Lungu wrote:
> Radu, consider the right chan... Radu Apetrii
03:17 AM Bug #7334: Reclaim used sessions to improve performance: Alexandru Lungu:
> Danut, please commit them for further review.
*Committed 7334a/rev.14641*. This will make the li... Dănuț Filimon

07/03/2023

03:16 PM Bug #7473: rewrite toString() implementation for Dataset, StaticTempTable and TempTableBuilder to...: Constantin Asofiei wrote:
> Ovidiu, that looks interesting; I think is better to have the legacy field name instead ... Ovidiu Maxiniuc
03:02 PM Bug #7473: rewrite toString() implementation for Dataset, StaticTempTable and TempTableBuilder to...: Ovidiu, that looks interesting; I think is better to have the legacy field name instead of column label or SQL field ... Constantin Asofiei
01:31 PM Bug #7473: rewrite toString() implementation for Dataset, StaticTempTable and TempTableBuilder to...: Please use @DataSet.getSqlData()@ and @RecordBuffer.sqlTableContent(N)@ instead. At least as a temporarily workaroun... Ovidiu Maxiniuc
09:48 AM Bug #7334: Reclaim used sessions to improve performance: I rebased 7334a to trunk. 7334a is now at rev. 14640. Alexandru Lungu
03:31 AM Bug #7334: Reclaim used sessions to improve performance: Danut, please focus on this task by testing DMO versioning. I am keen on merging 7334a asap.
In addition to #7334-... Alexandru Lungu
06:42 AM Feature #7459 (WIP): Implement BucketIndex in FWD-H2 to support multiplex: I've done some basic implementation for this just to test out the hypothesis. I have:... Alexandru Lungu
06:15 AM Bug #7474: FindQuery provides the wrong result because the record is not updated in the database: Take the following example:... Radu Apetrii
04:59 AM Feature #7066: Implement multi-table indexed query in H2: Hmm, I wonder if your logging also captures *multi-table @AdaptiveQuery@* that were optimized from @CQ@. My point: th... Alexandru Lungu
04:21 AM Feature #7066: Implement multi-table indexed query in H2: Alexandru Lungu wrote:
> * How many @CompoundQuery@ on _temp are there and how slow they are. We can use the FWD que... Radu Apetrii
03:33 AM Feature #7404: Trasform replace-mode into append-mode when target table is empty: Stefan, please focus exclusively on this task. I am planning to merge 7404a in trunk asap; but the regression should ... Alexandru Lungu
03:17 AM Bug #7138: Short circuit fake-update (update with a new value eqaul to the old value) in H2: Alexandru Lungu wrote:
> Danut, I rebased 7138a_h2 from FWD-H2 trunk (rev. 23). Please commit a patch to avoid fake-... Dănuț Filimon

07/02/2023

06:56 AM Bug #7473: rewrite toString() implementation for Dataset, StaticTempTable and TempTableBuilder to...: Is this also why looking at the content of Exceptions changes the exception ? Because we just spend an entire week de... Stefan Brands

07/01/2023

10:05 PM Bug #7467 (Review): join on meta table: Ovidiu Maxiniuc
10:04 PM Bug #7467: join on meta table: Constantin Asofiei wrote:
> Ovidiu, so this means that this 'recid relation' is automatically applied only to meta o... Ovidiu Maxiniuc

06/30/2023

08:57 AM Feature #7066: Implement multi-table indexed query in H2: Rebased 7066a and 7066a_h2 to latest FWD_H2 and FWD trunk. Alexandru Lungu
03:23 AM Feature #7066: Implement multi-table indexed query in H2: The work here is hanging still for a while. I've done a reread of the changes here.
Currently, multi-table queries... Alexandru Lungu
07:41 AM Bug #7474 (WIP): FindQuery provides the wrong result because the record is not updated in the dat...: Radu Apetrii
06:43 AM Bug #7473: rewrite toString() implementation for Dataset, StaticTempTable and TempTableBuilder to...: Constantin Asofiei wrote:
> Current implementation relies on WRITE-JSON, which has side-effects on the default buffe... Stefan Brands
06:34 AM Bug #7473: rewrite toString() implementation for Dataset, StaticTempTable and TempTableBuilder to...: Current implementation relies on WRITE-JSON, which has side-effects on the default buffer for the temp-table. This m... Constantin Asofiei
06:32 AM Bug #7473 (Test): rewrite toString() implementation for Dataset, StaticTempTable and TempTableBui...: Constantin Asofiei
06:30 AM Bug #7412: PresortQuery ORDER BY has to many clauses: I added it, committed to 7026e, revision 14647. Ștefan Roman
05:07 AM Bug #7412 (Review): PresortQuery ORDER BY has to many clauses: Stefan, please add a history entry to @src/com/goldencode/p2j/persist/PresortQuery.java@ regarding your changes. Don'... Alexandru Lungu
05:57 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2: *Review of 7454a_h2/rev.24*
* I am OK with the changes. Good job!
I will start a testing + profiling round and... Alexandru Lungu
05:36 AM Bug #7454 (Review): Make ValueStringIgnoreCase the default generated value for setString in FWD-H2: Alexandru Lungu
05:50 AM Bug #7421 (Review): Check only the indexes that were changed when using Validation.checkMaxIndexS...: > I've noticed that providing an offset that is greater or equal than 0 results in only one index being changed, this... Alexandru Lungu
05:04 AM Bug #7389 (Test): Make fast-copy statements cachable: Great. I will notify here when 7404a will be eventually merged. Alexandru Lungu
05:02 AM Feature #7076 (Test): make CAN-FIND avoid hydration: Alexandru Lungu
04:55 AM Bug #7334: Reclaim used sessions to improve performance: Alexandru Lungu wrote:
> Let me reiterate the protocol here. *Constantin, I would like a feedback on this.*
> * not... Constantin Asofiei
04:51 AM Bug #7334 (WIP): Reclaim used sessions to improve performance: Danut, please commit them for further review.
> I also have a question, if we consider that a lifespan with the va... Alexandru Lungu
04:23 AM Bug #7138 (WIP): Short circuit fake-update (update with a new value eqaul to the old value) in H2: I've double checked how many fake-updates are in another customer application and indeed I've got only to 1%. The per... Alexandru Lungu
03:32 AM Bug #7185 (Review): H2 in-memory lazy hydration: This will go in pending for a while. Eric is already doing some parallel work on lazy hydration so we may need to syn... Alexandru Lungu
02:49 AM Feature #7194 (Review): Avoid generating an ORDER-BY clause if not required: Radu, can you try creating the records in different transactions. I don't have a clear perspective yet on how the tes... Alexandru Lungu

06/29/2023

10:21 AM Bug #7412: PresortQuery ORDER BY has to many clauses: Done, I committed the changes on 7026e, revision 14605. Ștefan Roman
06:14 AM Bug #7412: PresortQuery ORDER BY has to many clauses: This can be optimized a bit further:
* Avoid using .size() in for - precompute it in another variable.
* Use @Sor... Alexandru Lungu
07:16 AM Bug #7389: Make fast-copy statements cachable: Alexandru Lungu wrote:
> The changes are good. However, I think this is quite related to #7404. Danut, please move 7... Dănuț Filimon
06:24 AM Bug #7389: Make fast-copy statements cachable: The changes are good. However, I think this is quite related to #7404. Danut, please move 7389a changes to 7404a - I ... Alexandru Lungu
04:21 AM Bug #7454: Make ValueStringIgnoreCase the default generated value for setString in FWD-H2: *Committed 7454a_h2/rev.24* which adds the @OPTIMIZE_IGNORE_CASE@ database property, it is *false* by default.
I c... Dănuț Filimon
03:14 AM Feature #7323: Implement soft unique index in FWD-H2: > I think we will need a statistic here. Radu, please feel free to count how many such cases actually occur in a cust... Alexandru Lungu

« Previous

Also available in: Atom

Project

General

Profile

FWD » Core Development » Database

Activity

Activity

07/29/2023

07/28/2023

07/27/2023

07/26/2023

07/25/2023

07/24/2023

07/22/2023

07/21/2023

07/20/2023

07/19/2023

07/18/2023

07/17/2023

07/16/2023

07/15/2023

07/14/2023

07/13/2023

07/12/2023

07/11/2023

07/10/2023

07/07/2023

07/06/2023

07/05/2023

07/04/2023

07/03/2023

07/02/2023

07/01/2023

06/30/2023

06/29/2023