Activity
From 08/19/2022 to 09/17/2022
09/17/2022
- 09:04 AM Database Bug #6766 (WIP): before-table options not inherited from the after-table (like NO-UNDO, SHARED, etc)
- At least the NO-UNDO options needs to be inherited by the before-table, if is set at the after-table.
The other of... - 09:02 AM Database Bug #6766 (WIP): before-table options not inherited from the after-table (like NO-UNDO, SHARED, etc)
- 05:22 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Ovidiu Maxiniuc wrote:
> Igor Skornyakov wrote:
> > Adding @indexof(text, text, boolean)@ and @lookup(text, text, b... - 09:40 PM Database Feature #6348: implement support for MariaDB
- I have committed r14399/6129a. It contains improved compatibility for sorting NULL high for MariaDb.
Note that, Mari...
09/16/2022
- 05:30 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Igor Skornyakov wrote:
> Adding @indexof(text, text, boolean)@ and @lookup(text, text, boolean)@ to @Functions@ fixe... - 11:09 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Igor Skornyakov wrote:
> It looks that we have problems with conversion of case-sensitive fields for MariaDB. We nee... - 10:59 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- It looks that we have problems with conversion of case-sensitive fields for MariaDB. We need to specify case-sensitiv...
- 05:15 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Igor Skornyakov wrote:
> Igor Skornyakov wrote:
> > There is a problem with creation of @SQLWarning@ with MariaDB. ... - 04:48 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Igor Skornyakov wrote:
> There is a problem with creation of @SQLWarning@ with MariaDB. Unlike PostgreSQL @RAISE NOT... - 01:59 PM Conversion Tools Feature #6237: OEUnit support
- > How global parameters in @cfg/p2j.cfg.xml@ do relate to uast hints?
They are read from @UastHints@ as the defau... - 01:16 PM Conversion Tools Feature #6237: OEUnit support
- Greg Shah wrote:
> Define a global parameter (in @cfg/p2j.cfg.xml@) for @OEUnit@ vs @ABLUnit@. Then add an override... - 11:58 AM Conversion Tools Feature #6237: OEUnit support
- Define a global parameter (in @cfg/p2j.cfg.xml@) for @OEUnit@ vs @ABLUnit@. Then add an override in the @UastHints@ ...
- 11:49 AM Conversion Tools Feature #6237: OEUnit support
- We have some difficulty if we are going to implement both @OEUnit@ and @ABLUnit@.
There is a difference in the usa... - 09:14 AM Conversion Tools Feature #6237: OEUnit support
- Marian Edu wrote:
> this is the only OEUnit I'm aware of - [[https://github.com/CameronWills/OEUnit]]
Yes, I m... - 01:55 AM Conversion Tools Feature #6237: OEUnit support
- Vladimir Tsichevski wrote:
> So we need to answer the following questions:
>
> # Whether or not and how class-l... - 09:48 AM Database Support #6713: check if it is faster to use separate temp-table instances instead of multiplex id
- Alexandru Lungu wrote:
> Please consider several "abstract" testcases (eventually with etime) which can show clear t... - 08:36 AM Database Feature #6418: represent extent fields as arrays
- The above is my opinion. Eric makes the final decision here.
- 08:36 AM Database Feature #6418: represent extent fields as arrays
- Some things to note:
* Customers hate normalized mode. We should simplify the runtime and get rid of it since the... - 05:16 AM Database Feature #6418: represent extent fields as arrays
- A few updates:
* I've tested the correctness of results regarding denormalized extent fields. Out of 108 tests that ... - 05:12 AM Database Feature #6695 (WIP): Multi-table preselect query may underperform due to repetitive fetching
- 02:26 AM Database Feature #6371: implement SAVE CACHE statement
- Boris Schegolev wrote:
> In the latest version (6371a/14102) I removed dependency on @DynamicTablesHelper@ completel...
09/15/2022
- 05:21 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- I see two problems which I've already seen with native PostgreSQL UDFs:
# We have to use @eq@, @ne@, @le@, ... UDFs... - 05:23 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Igor Skornyakov wrote:
> what is *not* registered are @indexOf@ and @lookup@ for signatures @[TEXT, TEXT, BOOLEAN]@ ... - 05:01 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- I consistently see the following log entries at the end of my UDFs' compatibility test:...
- 04:21 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Ovidiu Maxiniuc wrote:
> I do not understand. There is nothing particular to those functions. I did a quick test and... - 03:43 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Igor Skornyakov wrote:
> I will take a closer look tomorrow.
Using a debugger with a breakpoint in the @FqlToSq... - 05:06 PM Conversion Tools Feature #6237: OEUnit support
- > # Whether or not and how class-level annotations (@@BeforeClass@, @@AfterClass@) are used in 4gl procedures?
Ass... - 04:41 PM Conversion Tools Feature #6237: OEUnit support
- The latest problem reveals that we need to convert 4gl procedure annotation either.
So we need to answer the follo... - 04:55 PM Database Feature #6371: implement SAVE CACHE statement
- If (better said 'when') we will be able to cache the DMO generated classes we will surely have a boost for the startu...
- 04:22 PM Database Feature #6371: implement SAVE CACHE statement
- In the latest version (6371a/14102) I removed dependency on @DynamicTablesHelper@ completely. The code compiles, but ...
- 01:24 PM Database Bug #6699 (WIP): TemporaryBuffer$Multiplexer memory leak in global block
- There is still a leak in the @TransactionManager$WorkArea.globalBlock.finalizables@.
- 08:17 AM User Interface Feature #6764: Improve trigger selection for keyboard events.
- For keyboard events there is a specific order on which 4GL is looking for the right trigger to fire:
- key label
- ... - 08:15 AM User Interface Feature #6764 (Review): Improve trigger selection for keyboard events.
- 07:54 AM Database Feature #6763 (Rejected): implement configurable sizes (in the directory) for FastFindCache and O...
09/14/2022
- 03:33 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Ovidiu Maxiniuc wrote:
> I do not understand. There is nothing particular to those functions. I did a quick test and... - 03:29 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- I do not understand. There is nothing particular to those functions. I did a quick test and the functions are correct...
- 02:35 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- In the converted queries there are no 'signature suffix' for @indexOf@ and @lookup@.
Ovidiu, I undestand that the ... - 05:08 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- There is a problem with creation of @SQLWarning@ with MariaDB. Unlike PostgreSQL @RAISE NOTICE@, @SIGNAL SQLSTATE '01...
- 12:26 PM Conversion Tools Feature #6237: OEUnit support
- To add JUnit support to converted projects, the following patch has to be applied to @build.gradle@:...
- 11:29 AM Database Support #6713: check if it is faster to use separate temp-table instances instead of multiplex id
- Please consider several "abstract" testcases (eventually with @etime@) which can show clear time differences in diffe...
- 11:12 AM Database Feature #6582: implement multi-table AdaptiveQuery
- I committed 6582a/rev. 14164 including all the latest changes done to increase stability of the multi-table @Adaptive...
- 07:02 AM Base Language Feature #6754: complete BOM support for XmlHelper.readXMLEncoding()
- The "BOM":https://en.wikipedia.org/wiki/Byte_order_mark is bypassed in @XmlHelper.readXMLEncoding()@ but not yet hono...
- 07:00 AM Base Language Feature #6754 (New): complete BOM support for XmlHelper.readXMLEncoding()
09/13/2022
- 07:27 PM Database Feature #6457: finish COPY-LOB support
- > The BOM handling has a testcase already written. See @testcases/copy_lob/tests/bom.p@.
OK, the first issue I me... - 07:04 AM Database Feature #6457: finish COPY-LOB support
- The BOM handling has a testcase already written. See @testcases/copy_lob/tests/bom.p@.
- 02:22 PM Conversion Tools Feature #6237: OEUnit support
- Constantin Asofiei wrote:
> The code previously meant to allow @@LegacyService@ annotation in the 4GL code. Now i... - 01:43 PM Conversion Tools Feature #6237: OEUnit support
- Vladimir Tsichevski wrote:
> Constantin Asofiei wrote:
> > legacy_services.rules is built to allow @LegacyService@ ... - 01:40 PM Conversion Tools Feature #6237: OEUnit support
- Constantin Asofiei wrote:
> legacy_services.rules is built to allow @LegacyService@ annotations written directly in ... - 01:16 PM Conversion Tools Feature #6237: OEUnit support
- legacy_services.rules is built to allow @LegacyService@ annotations written directly in FWD code - these must be kept...
- 12:59 PM Conversion Tools Feature #6237: OEUnit support
- Constantin Asofiei wrote:
> Regarding 3821c/14239:
> * please format @annotations/unit_test_support.rules@ by inden... - 06:10 AM Conversion Tools Feature #6237: OEUnit support
- Regarding 3821c/14239:
* please format @annotations/unit_test_support.rules@ by indenting the nested @rules@ tags - ... - 01:49 PM Database Feature #6371: implement SAVE CACHE statement
- Ovidiu Maxiniuc wrote:
> Eric Faulhaber wrote:
> > What I am not sure about is from where we gather the legacy info... - 01:27 PM Database Feature #6371: implement SAVE CACHE statement
- Eric Faulhaber wrote:
> What I am not sure about is from where we gather the legacy information (i.e., the informati... - 01:38 AM Database Feature #6371: implement SAVE CACHE statement
- Boris Schegolev wrote:
> I updated @DatabaseManager@ to handle registration of the new interface.
I didn't really... - 01:16 PM Database Feature #6582: implement multi-table AdaptiveQuery
- The non-scrolling query examples that were working on 3821c are now working properly on 6582a as well. Note that I mo...
- 10:30 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Eric Faulhaber wrote:
> Any issues coming out of testing? Any headway on the error handling solution? Thanks.
Not... - 10:09 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Any issues coming out of testing? Any headway on the error handling solution? Thanks.
- 10:16 AM Database Feature #6453 (WIP): temp-table features
09/12/2022
- 05:42 PM Conversion Tools Feature #6237: OEUnit support
- Conversion of 4gl annotations to JUnit5 Java annotations implemented in 3821c rev. 14239.
- 04:05 PM Database Feature #6371: implement SAVE CACHE statement
- I updated @DatabaseManager@ to handle registration of the new interface. I am still working on removal of the last ca...
- 12:27 PM Database Support #6679: H2 general performance tuning
- Is the H2 storage engine API implemented in a clean manner or is the storage engine implemented as pieces of code spr...
- 08:39 AM Database Support #6679: H2 general performance tuning
- > I wonder if there is any case in which a physical 4GL user can have multiple transactions to one single temporary t...
- 08:35 AM Database Support #6679: H2 general performance tuning
- Greg Shah wrote:
> Clearly, we cannot move ahead with the new version of H2. At least we cannot without something th... - 05:44 AM Database Support #6679: H2 general performance tuning
- Clearly, we cannot move ahead with the new version of H2. At least we cannot without something that changes the perf...
- 05:24 AM Database Support #6679: H2 general performance tuning
- Eric Faulhaber wrote:
> I don't know how the tests were performed for the bottom table, which actually is the more ... - 10:10 AM Database Feature #6348: implement support for MariaDB
- I've found the following tool which can be useful - https://www.linuxbabe.com/ubuntu/mysql-mariadb-database-performan...
- 06:11 AM Database Feature #6348: implement support for MariaDB
- Igor Skornyakov wrote:
> It looks that we need to use @timestamp(3)@/@datetime(3)@ instead of @timestamp@/@datetime@... - 05:07 AM Database Feature #6453: temp-table features
- 6129a
- 04:53 AM Database Feature #6453: temp-table features
- Ovidiu,
Which branch should I use for this task?
Thank you.
09/10/2022
- 04:24 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
- I've reviewed @ca_upd_20220909a_3821c_14233.zip@ update (the persistence portions, mostly).
I think overall this l...
09/09/2022
- 12:38 PM Base Language Bug #6743: fix GET-SIGNATURE for all parameter modes and types
- 6129a/14390 fixes TABLE-HANDLE, DATASET, DATASET-HANDLE parameters reported by GET-SIGNATURE.
Other part which I d... - 11:39 AM Base Language Bug #6743: fix GET-SIGNATURE for all parameter modes and types
- FWD doesn't report properly the signature; we need to check and fix this for all parameter types, extent, DATASET,DAT...
- 11:38 AM Base Language Bug #6743 (New): fix GET-SIGNATURE for all parameter modes and types
- 12:13 PM Database Bug #6744: rollback when there are catch/finally blocks opening their own transactions
- I'm seeing an abend with a customer app where a savepoint is no longer valid (when trying to rollback-/commit-). I'v...
- 12:08 PM Database Bug #6744 (New): rollback when there are catch/finally blocks opening their own transactions
- 12:08 PM Database Feature #6453: temp-table features
- Ovidiu Maxiniuc wrote:
> Igor, I think @PRIMARY@ has already been implemented in branch 6129a. I think that is your ... - 12:06 PM Database Feature #6453: temp-table features
- Igor, I think @PRIMARY@ has already been implemented in branch 6129a. I think that is your target. Anyway that branch...
- 12:30 AM Database Feature #6453: temp-table features
- Igor, please see #6453-3 and ask Ovidiu any questions you have.
- 12:05 PM Database Bug #6699 (Review): TemporaryBuffer$Multiplexer memory leak in global block
- The fix for this is in #6641-34, 6129a rev 14388.
- 10:19 AM Database Bug #6699: TemporaryBuffer$Multiplexer memory leak in global block
- Eric Faulhaber wrote:
> Constantin Asofiei wrote:
> > I think I have a better fix for this leak; in @TemporaryBuffe... - 10:19 AM Database Bug #6699: TemporaryBuffer$Multiplexer memory leak in global block
- Constantin Asofiei wrote:
> I think I have a better fix for this leak; in @TemporaryBuffer.initialize@ do this:
> [... - 05:49 AM Database Bug #6699: TemporaryBuffer$Multiplexer memory leak in global block
- I think I have a better fix for this leak; in @TemporaryBuffer.initialize@ do this:...
- 10:17 AM Database Feature #6582: implement multi-table AdaptiveQuery
- I started using the tests from @uast/adaptive_scrolling@ to test the changes for multi-table @AdaptiveQuery@. Almost ...
- 06:05 AM Database Feature #6418: represent extent fields as arrays
- Small update on this topic: I ran the tests from the previous post, but with a small change regarding the tables. Ins...
- 04:51 AM Database Feature #6348: implement support for MariaDB
- It looks that we need to use @timestamp(3)@/@datetime(3)@ instead of @timestamp@/@datetime@ in the tables' DDL for Ma...
- 02:11 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
- Eric, I'm attaching the changes directly, please apply them over 3821c/14233 and review the p2j.persist part. Thanks.
- 01:43 AM Database Bug #6741: Word index support for MariaDB.
- Implement word index support for MariaDB using word tables
- 01:41 AM Database Bug #6741 (New): Word index support for MariaDB.
- 01:40 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Eric Faulhaber wrote:
> Is there any value in implementing a @CONTAINS@ UDF? As I recall, we can't fully support the... - 12:46 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Igor Skornyakov wrote:
> Finished port of PostgreSQL UDFs (except ones related to error handling and word tables) to... - 12:23 AM Database Feature #6507: cross-database joins
- Greg Shah wrote:
> Is there a reason to implement this for a specific database backend?
Yes. Some databases (e.g.... - 11:01 PM Database Support #6679: H2 general performance tuning
- Dănuț Filimon wrote:
> Alexandru Lungu wrote:
> > retest the Hotel GUI examples from #6679-21. Check if we have reg...
09/08/2022
- 07:24 PM Database Bug #6703 (WIP): loading schema table DMO interface with no defined fields
- Constantin, I reviewed it and your fix in 6129a/14273 seems logical.
I also added two changes in 6129a/14387:
* @... - 12:58 PM User Interface Bug #6740: re-enable FRAME_LOCK in annotations/embedded_attribute_assign_rewrite and determine wh...
- In #6726, it was measured ~10k calls of @LT.flushEnqueuedWidgetAttrs@. Some of these calls are part of a @CREATE <wi...
- 12:55 PM User Interface Bug #6740 (New): re-enable FRAME_LOCK in annotations/embedded_attribute_assign_rewrite and determ...
- 10:13 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
- Eric Faulhaber wrote:
> Code Review scopeable_6650_patch_20220901a.patch:
>
> I did not find a revised patch with... - 10:38 PM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
- Code Review scopeable_6650_patch_20220901a.patch:
I did not find a revised patch with the #6650-14 changes after G... - 03:37 AM Conversion Tools Feature #6237: OEUnit support
- I always use the @String@ methods directly (@equals()@ or @equalsIgnoreCase()@). Even if we did implement string con...
09/07/2022
- 04:16 PM Database Support #6713: check if it is faster to use separate temp-table instances instead of multiplex id
- Eric Faulhaber wrote:
> I thought this naming convention was just for the DMO interfaces. When did we start using th... - 03:52 PM Database Support #6713: check if it is faster to use separate temp-table instances instead of multiplex id
- Ovidiu Maxiniuc wrote:
> We are already forced to use a naming schema for temp-tables as @<converted-original-name... - 01:52 PM Database Support #6713: check if it is faster to use separate temp-table instances instead of multiplex id
- The investigation should take into account that, beside the expected direct SQL internal benefits, should also includ...
- 02:58 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Finished port of PostgreSQL UDFs (except ones related to error handling and word tables) to MariaDB.
Committed to 61... - 02:02 PM Conversion Tools Feature #6237: OEUnit support
- Greg Shah wrote:
> In TRPL, are we mapping @annoName == "Before"@ to @String.equalsIgnoreCase()@?
I did not know th... - 01:40 PM Conversion Tools Feature #6237: OEUnit support
- Vladimir Tsichevski wrote:
> Greg Shah wrote:
>
> >
> > Does this make sense?
>
> If I get it right, then:
... - 01:39 PM Conversion Tools Feature #6237: OEUnit support
- In TRPL, are we mapping @annoName == "Before"@ to @String.equalsIgnoreCase()@? If not then shouldn't we do that expl...
- 01:38 PM Conversion Tools Feature #6237: OEUnit support
- Greg Shah wrote:
>
> Does this make sense?
If I get it right, then:
# We can execute on the server side an... - 12:52 PM Conversion Tools Feature #6237: OEUnit support
- Greg Shah wrote:
> > The question is in which module this javaName is assigned? It would be better to calculate the ... - 12:48 PM Conversion Tools Feature #6237: OEUnit support
- Greg Shah wrote:
> Please rename both @oeunit.rules@ files to @unit_test_support.rules@. Remember that we are imple... - 12:35 PM Conversion Tools Feature #6237: OEUnit support
- Vladimir: Please post questions or comments here. As a next step, I'd like to see the proposed design of the @Remote...
- 12:29 PM Conversion Tools Feature #6237: OEUnit support
- Please rename both @oeunit.rules@ files to @unit_test_support.rules@. Remember that we are implementing support for ...
- 12:27 PM Conversion Tools Feature #6237: OEUnit support
- Vladimir Tsichevski wrote:
> I suppose, the Java method, produced by conversion of a 4gl class, must be called in so... - 11:56 AM Conversion Tools Feature #6237: OEUnit support
- > The question is in which module this javaName is assigned? It would be better to calculate the correct value for th...
- 01:25 PM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
- > Greg: I haven't yet decoupled TransactionManager from the direct references to BufferManager/LogicalTerminal, I'll ...
- 09:43 AM Database Feature #6418: represent extent fields as arrays
- I've done some more testing, this time regarding the SQLs for three different approaches of storing an extent field a...
- 09:37 AM Conversion Tools Bug #6738: incremental conversion when deleting program or class files
- Allow incremental conversion to detect program or class files which have been deleted, and cleanup after it (includin...
- 09:36 AM Conversion Tools Bug #6738 (Closed): incremental conversion when deleting program or class files
- 09:25 AM Database Support #6679: H2 general performance tuning
- Alexandru Lungu wrote:
> retest the Hotel GUI examples from #6679-21. Check if we have regressions with prepared sta... - 02:09 AM Database Support #6679: H2 general performance tuning
- Eric Faulhaber wrote:
> Is this something which is fixed with the patched v214?
No, this is related to the FWD ...
09/06/2022
- 02:34 PM Database Support #6679: H2 general performance tuning
- I'm trying to use H2 v214 to see if it still shows a memory leak I see when running a converted application with v200...
- 10:15 AM Database Support #6679: H2 general performance tuning
- Some things to note for your testing:
* We do not use persistent tables with H2 for customer applications. All use... - 09:56 AM Database Support #6679: H2 general performance tuning
- Alexandru Lungu wrote:
> retest 2.1.210 (and eventually 2.1.212 and 2.1.214) with one-by-one strategy. Check if we s... - 02:25 PM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
- The latest patch is attached, built on top of 3821c/14225. I need to finish testing with other apps, there is an iss...
- 08:53 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
- There is an inherent feature of @ScopedDictionary@, where 'global' scope is used: this is not something created by th...
- 11:55 AM Conversion Tools Feature #6237: OEUnit support
- I suppose, the Java method, produced by conversion of a 4gl class, must be called in some special way?
- 11:35 AM Conversion Tools Feature #6237: OEUnit support
- Now that I have all Junit5 annotations in place, I have another problem when I try to run the @SimpleTest@ class as J...
- 11:26 AM Database Feature #6582: implement multi-table AdaptiveQuery
- Alexandru Lungu wrote:
in my mind, the "dynamic mode" is still initially represented by the CompundQuery b... - 11:24 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching
- - removed the comment -
It was meant to be posted in #6582
09/05/2022
- 06:27 PM Conversion Tools Feature #6237: OEUnit support
- I've added support for JUnit 5 annotations generation from OEUnit annotations.
3 things changed:
# Code which d... - 02:25 PM Conversion Tools Feature #6237: OEUnit support
- The question is in which module this @javaName@ is assigned? It would be better to calculate the correct value for th...
- 02:22 PM Conversion Tools Feature #6237: OEUnit support
- Greg Shah wrote:
> > What am I doing wrong here? I know setting text works on the copy:
>
> The problem is subtle... - 02:28 AM Conversion Tools Feature #6237: OEUnit support
- > The first will be called from "annotations.xml", and do Java annotations preparation, the second will be called fro...
- 02:27 AM Conversion Tools Feature #6237: OEUnit support
- > What am I doing wrong here? I know setting text works on the copy:
The problem is subtle. The @setText()@ you a... - 04:21 PM Database Feature #6371: implement SAVE CACHE statement
- It is not ideal to use @DynamicTablesHelper@ (in its current form) to create persistent table DMO interfaces/classes....
- 03:47 PM Database Support #6679: H2 general performance tuning
- Alexandru Lungu wrote:
> [...]
Thank you for the explanation.
> I will update Performance_Testing_the_H2_Datab... - 12:12 PM Database Support #6679: H2 general performance tuning
- The tests from our current Performance_Testing_the_H2_Database are decent for 1.4.200, but are no quite accurate for ...
- 10:31 AM Database Support #6679: H2 general performance tuning
- Dănuț Filimon wrote:
> Eric Faulhaber wrote:
> > Dănuț Filimon wrote:
> > > Committed fwd-h2/rev.9. I applied a fe... - 09:46 AM Database Support #6679: H2 general performance tuning
- Eric Faulhaber wrote:
> Dănuț Filimon wrote:
> > Committed fwd-h2/rev.9. I applied a few changes from versions 2.1.... - 02:22 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Ported the following UDF: ...
- 03:55 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- I was thinking about error handling support ('guarded' UDFs) for MariaDB.
It looks that it can be implemented using ... - 04:28 AM Database Feature #6418: represent extent fields as arrays
- > The question I would like to ask is: Is there any reason why normalized is preferred over denormalized, since the l...
- 02:58 AM Database Feature #6418: represent extent fields as arrays
- I have tested these two methods of representing extent fields (normalized and denormalized) over a series of tests an...
- 04:22 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
- I think you can go ahead and check in your first pass changes from #6650-14. Or did you plan to check it in with the...
- 01:57 AM Database Feature #2137: runtime support for FIELDS/EXCEPT record phrase options
- I was in a session the other day which was offered at the PUG Challenge 2022. This was presented by Gus, who designe...
09/03/2022
- 05:17 PM Conversion Tools Feature #6237: OEUnit support
- Eric Faulhaber wrote:
> I think you are conflating the annotations phase of conversion (when @annotations.xml@ and a... - 03:52 PM Conversion Tools Feature #6237: OEUnit support
- I think you are conflating the annotations phase of conversion (when @annotations.xml@ and all its related rule-sets ...
- 06:33 AM Conversion Tools Feature #6237: OEUnit support
- Help needed.
I have to insert Java *import statements*. I gathered, I can use the @ConverterHelper.createImport()@...
09/02/2022
- 03:24 PM Conversion Tools Feature #6237: OEUnit support
- I wrote an additional rule-set which replaces OEUnit 4gl annotation names to corresponding JUnit 5 names.
The prob... - 02:14 PM Database Feature #6720: lazy hydration
- If we are to lazily hydrate records, any column data which was not loaded in the initial hydration pass will have to ...
- 01:03 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Ported the following UDFs: ...
- 04:06 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Ported the following UDFs: ...
- 12:14 PM Runtime Infrastructure Bug #6671: Build configurations need "fine tuning"
- I suppose that's how we got to this point. It's difficult if you don't keep the dependencies as light as possible as ...
- 11:31 AM Runtime Infrastructure Bug #6671: Build configurations need "fine tuning"
- Roger Borrello wrote:
> Hynek Cihlar wrote:
> > Roger, you will have to add the required dependencies, previously i... - 11:28 AM Runtime Infrastructure Bug #6671: Build configurations need "fine tuning"
- Hynek Cihlar wrote:
> Roger, you will have to add the required dependencies, previously included by Janus graph, man... - 11:21 AM Runtime Infrastructure Bug #6671: Build configurations need "fine tuning"
- Roger, you will have to add the required dependencies, previously included by Janus graph, manually back to the Serve...
- 11:11 AM Runtime Infrastructure Bug #6671: Build configurations need "fine tuning"
- I ran 2 builds of 3821c, the difference between them was build A had @janusgraph-core 0.1.0@ as part of both the Conv...
- 10:47 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
- > LT will still exist, but TC will be on the server-side. If we remove LT, this would mean frames are no longer being...
- 07:37 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
- Greg Shah wrote:
> Code Review scopeable_6650_patch_20220901a.patch
>
> Overall, I think the changes are quite go... - 06:39 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
- Eric Faulhaber wrote:
> > Something I forgot to mention - there are some methods in BufferManager which are never ca... - 06:27 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
- Code Review scopeable_6650_patch_20220901a.patch
Overall, I think the changes are quite good.
My concern is m... - 06:22 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
- Constantin Asofiei wrote:
> Eric: if you can give me some hints at extracting BufferManager's tx scope support, I ca... - 10:26 AM Database Support #6679: H2 general performance tuning
- Dănuț Filimon wrote:
> Eric Faulhaber wrote:
> > Have you discovered any cases where H2 v2.1.210patched was slower ... - 09:46 AM Database Support #6679: H2 general performance tuning
- Eric Faulhaber wrote:
> Have you discovered any cases where H2 v2.1.210patched was slower than v1.4.200patched (Page... - 09:07 AM Database Feature #6418 (WIP): represent extent fields as arrays
- 09:06 AM Database Support #6713 (WIP): check if it is faster to use separate temp-table instances instead of multip...
- 04:20 AM Base Language Feature #1970: improve ControlFlowOps method resolution by reflection
- This makes sense.
- 02:47 AM Database Feature #6729: improve database and temp-table toString to write all records without relying on w...
- This is in my opinion a very important problem that needs to be fixed asap. Enabling the DataSet.fullDebugString allo...
09/01/2022
- 03:59 PM Database Support #6679: H2 general performance tuning
- Thank you for all the research and testing. In all the work so far...
* Have you discovered any cases where H2 v2.... - 11:48 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
- Eric: if you can give me some hints at extracting BufferManager's tx scope support, I can give it a try. To me, it l...
- 09:37 AM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
- You can apply the patch using:...
- 09:37 AM Base Language Feature #6650 (WIP): improve performance of Scopeable notification in TM.processScopeNotifications
- The changes are attach. Greg/Eric: please review and let me know if you see something dangerous.
The patch is on ... - 11:01 AM Base Language Feature #1970: improve ControlFlowOps method resolution by reflection
- Greg Shah wrote:
> The tricky part is that at the call site, we would have some configuration/data that is dynamic o... - 09:27 AM Runtime Infrastructure Support #5567: move FWD to Java 11
- > But I think we should do an upgrade of all libraries to current/latest releases.
I agree with the idea that we w... - 07:21 AM Runtime Infrastructure Support #5567: move FWD to Java 11
- Greg Shah wrote:
>
> Otherwise, if we need more analysis, please suggest the next steps.
I have another idea - ta...
08/31/2022
- 02:50 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Ported the following UDFs: ...
- 09:33 AM Database Feature #6729: improve database and temp-table toString to write all records without relying on w...
- We need to allow the dataset or temp-table 'toString' representation (like in a debugger) to show all records in all ...
- 09:30 AM Database Feature #6729 (New): improve database and temp-table toString to write all records without relyin...
- 08:51 PM Runtime Infrastructure Support #5567: move FWD to Java 11
- To be more clear, the customer has not done any further testing or analysis and they are not planning to do so. Your...
08/30/2022
- 07:51 PM Runtime Infrastructure Feature #5776: reduce memory requirements for the FWD client
- Will this change the results of our testing in #6560?
- 07:51 PM Runtime Infrastructure Feature #5776: reduce memory requirements for the FWD client
- Tomasz: Go ahead and merge the 5776-3.diff changes.
- 03:33 PM Database Feature #6371: implement SAVE CACHE statement
- I pushed the latest version (see revision 6371a/14100). I tried to use existing DynamicTablesHelper implementation in...
- 02:01 PM Database Feature #4722: data import should be able to run with only the converted application jar file (an...
- Constantin Asofiei wrote:
> Import always requires @ant deploy.prepare@, as it needs the application's jar. Did you... - 01:49 PM Database Feature #4722: data import should be able to run with only the converted application jar file (an...
- Import always requires @ant deploy.prepare@, as it needs the application's jar. Did you have this in our @deploy/lib...
- 01:48 PM Database Feature #4722: data import should be able to run with only the converted application jar file (an...
- The issue was that I had been trying to link p2j to the @convert@ deployment and *not* run @ant deploy.prepare@, whic...
- 11:40 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Eric Faulhaber wrote:
> Igor Skornyakov wrote:
> > Igor Skornyakov wrote:
> > > This revision should be OK. Let m... - 11:19 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Igor Skornyakov wrote:
> Igor Skornyakov wrote:
> > This revision should be OK. Let me test the imports with my ve... - 10:37 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Igor Skornyakov wrote:
> This revision should be OK. Let me test the imports with my version of MariaDB.
Eric. W... - 10:28 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Eric Faulhaber wrote:
> I was using 3821c/14206. The latest revision is 14207, but I do not see a newer version of @... - 09:39 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Igor Skornyakov wrote:
> Eric Faulhaber wrote:
> > Igor, is MariaDB 10.8 the minimum version on which the UDFs are ... - 04:21 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Eric Faulhaber wrote:
> Igor, is MariaDB 10.8 the minimum version on which the UDFs are supported? I've been trying ... - 04:07 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Igor, is MariaDB 10.8 the minimum version on which the UDFs are supported? I've been trying to get Hotel GUI going wi...
- 07:16 AM Database Support #6679: H2 general performance tuning
- Eric Faulhaber wrote:
> The statements under test ultimately were the same for 200patched and 210patched, correct?
... - 06:12 AM Database Support #6679: H2 general performance tuning
- Committed fwd-h2/rev.7 containing version 2.1.210 without any patches from version 1.4.200.
Committed fwd-h2/rev.8...
08/29/2022
- 02:53 PM Base Language Feature #6650: improve performance of Scopeable notification in TM.processScopeNotifications
- I can not find a good way to limit BufferManager/ChangeBroker. I have changes which sync them (so they are always no...
- 12:56 PM Database Feature #4722: data import should be able to run with only the converted application jar file (an...
- Greg Shah wrote:
> > Could that be where the issue is? Should the jar include these in the cvt directory?
>
> Yes... - 09:48 AM Database Feature #4722: data import should be able to run with only the converted application jar file (an...
- > Could that be where the issue is? Should the jar include these in the cvt directory?
Yes and probably yes. You ... - 09:41 AM Database Feature #4722: data import should be able to run with only the converted application jar file (an...
- Using a conversion with 3821c_14194, my @ant import@ for a customer application is receiving this in the import log:
... - 08:28 AM Runtime Infrastructure Support #5567: move FWD to Java 11
- Tomasz Domin wrote:
> Greg Shah wrote:
> > OK, so far this looks like it is consistent with the customer's early fi... - 08:21 AM Runtime Infrastructure Support #5567: move FWD to Java 11
- Greg Shah wrote:
> OK, so far this looks like it is consistent with the customer's early findings (i.e. Java 8 is 10... - 06:32 AM Runtime Infrastructure Support #5567: move FWD to Java 11
- Rebased to 3821c/14205, pushed 5567a/14223
- 07:21 AM Database Feature #6720: lazy hydration
- In query processing, it is my understanding that a substantial percentage of time is spent in hydration of returned r...
- 06:39 AM Database Feature #6720 (WIP): lazy hydration
- 07:03 AM Database Feature #6721: calculate field lists at conversion time where possible
- There are use cases of buffers in which it is not possible to statically calculate the exact fields used at runtime (...
- 06:54 AM Database Feature #6721 (New): calculate field lists at conversion time where possible
- 06:21 AM Database Support #6679: H2 general performance tuning
- After running some tests regarding the performances of 4GL, SQL and P2J, I have generated a table that is meant to de...
- 05:40 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching
- I added 3821c/rev. 14206 including a new MBean for query profiling: @QueryProfiler@. It stores a map from an SQL prep...
- 04:53 AM Database Bug #6699: TemporaryBuffer$Multiplexer memory leak in global block
- Constantin Asofiei wrote:
> Actually, the previous patch is incorrect. I think this code in @TemporaryBuffer.define...
08/28/2022
- 04:30 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching
- Greg Shah wrote:
> Actually, it looks like the documentation already exists in [[p2j:Profiling#JMX-MBean-Instrumenta...
08/27/2022
- 11:57 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Added @rindexof_<suffix>@, @rtrimws_<suffix>@, and @lc_t@ UDFs corresponding to @R-INDEX@, @RIGHT-TRIM@ and @LC@ 4GL ...
- 08:27 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Implemented @substitute_tf@ UDF (see #6628-102).
Committed to 3821c/14202. - 05:19 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Igor Skornyakov wrote:
> I think that we can implement a @substitute@ for MariaDB as a two-argument UDF with JSON ... - 05:15 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- > I think that we can implement a @substitute@ for MariaDB as a two-argument UDF with JSON array as a second argument...
- 03:01 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Eric Faulhaber wrote:
> @substitute@ could be used as a UDF, but it is not in this initial application. Again, this ... - 09:41 PM Database Bug #6275 (Review): SKIP-DELETED-RECORD implementation
- 09:41 PM Database Bug #6275 (WIP): SKIP-DELETED-RECORD implementation
- 09:40 PM Database Bug #6275: SKIP-DELETED-RECORD implementation
- > A single question: calls to @stopOnSkippedRecord@ occur on @first@, @next@, and @previous@ navigation. Shouldn't th...
08/26/2022
- 03:06 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Ported the following UDFs: ...
- 12:55 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Eric Faulhaber wrote:
> For the initial application (at least based on static code analysis), only @r-index@ and @ri... - 10:53 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- For the initial application (at least based on static code analysis), only @r-index@ and @right-trim@ are used in con...
- 04:01 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Eric Faulhaber wrote:
> The following is a list of 4GL builtin functions used within WHERE clauses, based on their p... - 12:12 PM Database Feature #6371: implement SAVE CACHE statement
- Yes, something like that, but please note I've already stubbed out @DatabaseManager.schemaChanged@ in 6371a/14098. Pl...
- 12:02 PM Database Feature #6371: implement SAVE CACHE statement
- So, the integration part should be something like that, right?...
- 03:17 AM Database Feature #6371: implement SAVE CACHE statement
- 6371a/14098 contains a first pass implementation of conversion support for SAVE CACHE. The statement converts to a st...
- 10:56 AM Database Bug #6715: BufferManager.validate throws IllegalStateException if a validation fails via a Valida...
- Converting a legacy error into an abend seems like something easily avoided.
- 03:47 AM Database Bug #6715: BufferManager.validate throws IllegalStateException if a validation fails via a Valida...
- If validation fails in @BufferManager.validate@, this abends:...
- 03:45 AM Database Bug #6715 (New): BufferManager.validate throws IllegalStateException if a validation fails via a ...
- 04:08 AM Database Bug #6703: loading schema table DMO interface with no defined fields
- A fix for the DMO interface loading (for runtime and DB import) is in 6129a/14273.
This does not solve all issues,...
08/25/2022
- 06:03 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Eric Faulhaber wrote:
> This list comes from an application which we must support fully on MariaDB in September. P... - 05:59 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Igor Skornyakov wrote:
> Eric Faulhaber wrote:
> > So, porting these final 10 gets us to parity with the other dial... - 05:41 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Eric Faulhaber wrote:
> Does this mean 306 of 316 Maria UDFs are implemented now? As I understand it, the 316 total ... - 05:26 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Igor Skornyakov wrote:
> Ported the following UDFs:
> [...]
>
> Committed to 3821c/14199.
>
> The following ... - 04:08 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Ported the following UDFs: ...
- 01:06 PM Database Bug #6688 (Closed): ASSIGN trigger conversion when field has DECIMALS clause
- Constantin Asofiei wrote:
> Ovidiu Maxiniuc wrote:
> > With 3821c your testcases correctly converts to
> > [...]
... - 12:30 PM Database Support #6714: check if there is an optimization opportunity when copying temp-tables based on mu...
- It seems to me that when processing certain temp-table copying use cases, there may be an opportunity for optimizatio...
- 12:24 PM Database Support #6714 (Review): check if there is an optimization opportunity when copying temp-tables ba...
- 12:18 PM Database Support #6713: check if it is faster to use separate temp-table instances instead of multiplex id
- It seems like for tables with very large numbers of records might be slow when using a multiplex approach as opposed ...
- 12:17 PM Database Support #6713 (WIP): check if it is faster to use separate temp-table instances instead of multip...
- 12:15 PM Database Support #6712: check generated dynamic temp-table caching to ensure that all cache keys work when...
- Greg Shah wrote:
> Recently, Eric found a flaw in our cache key implementation which resulted in the cache entry not... - 12:12 PM Database Support #6712: check generated dynamic temp-table caching to ensure that all cache keys work when...
- Recently, Eric found a flaw in our cache key implementation which resulted in the cache entry not being properly foun...
- 12:09 PM Database Support #6712 (New): check generated dynamic temp-table caching to ensure that all cache keys wor...
- 11:58 AM Database Feature #6711: skip schema AST creation and go directly to .p2o in dynamic temp-table generation
- With relatively minor changes to the conversion, we could skip schema AST creation and go directly to .p2o in dynamic...
- 11:57 AM Database Feature #6711 (New): skip schema AST creation and go directly to .p2o in dynamic temp-table gener...
- 11:56 AM Database Feature #6710: persist dynamic temp-tables across server restarts
- A customer (thank you Stefan!) suggested that we could cache the generated DMOs etc... for dynamic temp-tables such t...
- 11:55 AM Database Feature #6710 (New): persist dynamic temp-tables across server restarts
- 11:54 AM Database Support #6709: track nested FIND inside a related FOR loop
- We have the perception that we have a problem with nested FINDs that reference a buffer or buffers controlled by a co...
- 11:49 AM Database Support #6709 (Review): track nested FIND inside a related FOR loop
- 11:47 AM Database Support #6708: track/report at runtime when AdaptiveQuery shifts into dynamic mode
- It seems that we may shift into dynamic mode in @AdaptiveQuery@ more frequently than one might expect. I would have ...
- 11:42 AM Database Support #6708 (Review): track/report at runtime when AdaptiveQuery shifts into dynamic mode
- 11:37 AM Database Support #6707: evaluate the effectiveness of the current approach to ProgressiveResults
- Currently @ProgressiveResults@ always starts with a set size of 1. This was done because the following idiom was see...
- 11:30 AM Database Support #6707 (New): evaluate the effectiveness of the current approach to ProgressiveResults
- 11:33 AM Database Bug #6699: TemporaryBuffer$Multiplexer memory leak in global block
- Actually, the previous patch is incorrect. I think this code in @TemporaryBuffer.define@ at line 1668 (branch 6129a)...
- 10:26 AM Database Bug #6699: TemporaryBuffer$Multiplexer memory leak in global block
- The fix is this:...
- 09:25 AM Database Bug #6699: TemporaryBuffer$Multiplexer memory leak in global block
- The recreate is this:...
- 11:19 AM Conversion Tools Bug #6706: preserve existing camel-case usage in program names
- We have a customer that deliberately uses camel-case in their program names (especially in OO classes). The current ...
- 11:17 AM Conversion Tools Bug #6706 (New): preserve existing camel-case usage in program names
- 10:05 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching
- I had forgotten too. It was Alexandru's note in #6695-11 that reminded me. ;)
- 09:36 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching
- Greg Shah wrote:
> Actually, it looks like the documentation already exists in [[p2j:Profiling#JMX-MBean-Instrumen... - 09:28 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching
- Igor Skornyakov wrote:
> Greg Shah wrote:
> > Yes, no problem.
>
> Greg,
> It looks that I need some time to re... - 07:45 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching
- Greg Shah wrote:
> Yes, no problem.
Greg,
It looks that I need some time to recall the details. Maybe I will pre... - 05:34 AM Database Bug #6703: loading schema table DMO interface with no defined fields
- If the .df has a table with no fields defined, import or loading this DMO interface fails with this:...
- 05:33 AM Database Bug #6703 (WIP): loading schema table DMO interface with no defined fields
- 03:49 AM Database Feature #6582: implement multi-table AdaptiveQuery
- I attached here the query conversion tests I used for reference. These are procedures which have structures involving...
- 03:13 AM Runtime Infrastructure Support #5567: move FWD to Java 11
- I am done with performance comparison between Java 8 and Java 11 in real-life like test scenarios.
I've managed to g...
08/24/2022
- 05:39 PM Runtime Infrastructure Feature #6364: implement an option to use Tomcat instead of Jetty as the embedded webserver/servl...
- The customer that requested this feature is mentioned that they depend upon a peculiar behavior of Tomcat. Tomcat lo...
- 05:19 PM Database Feature #6700: refactor prodataset conversion to generate a separate/common class which can be re...
- Similar to how we convert temp-tables, the idea is to refactor the code to have datasets convert as a separate class ...
- 05:11 PM Database Feature #6700 (New): refactor prodataset conversion to generate a separate/common class which can...
- 04:56 PM Conversion Tools Feature #6237: OEUnit support
- Constantin Asofiei wrote:
> Vladimir, the OE annotations (any kind) are processed in @annotations/legacy_services.ru... - 01:31 PM Conversion Tools Feature #6237: OEUnit support
- Vladimir, the OE annotations (any kind) are processed in @annotations/legacy_services.rules@. At the time, I did not...
- 01:21 PM Conversion Tools Feature #6237: OEUnit support
- Greg Shah wrote:
> Vladimir Tsichevski wrote:
> > OEUnit uses 4gl annotations to mark methods. I do not see these a... - 01:11 PM Conversion Tools Feature #6237: OEUnit support
- Vladimir Tsichevski wrote:
> OEUnit uses 4gl annotations to mark methods. I do not see these annotations in AST file... - 12:40 PM Conversion Tools Feature #6237: OEUnit support
- Tomasz Domin wrote:
> Vladimir Tsichevski wrote:
> > Greg Shah wrote:
> > > We took a short cut, which is why it s... - 11:11 AM Conversion Tools Feature #6237: OEUnit support
- Vladimir Tsichevski wrote:
> Greg Shah wrote:
> > We took a short cut, which is why it smells. Yes, there is techn... - 11:03 AM Conversion Tools Feature #6237: OEUnit support
- OEUnit uses 4gl annotations to mark methods. I do not see these annotations in AST files. It seems, these annotation ...
- 06:05 AM Conversion Tools Feature #6237: OEUnit support
- Greg Shah wrote:
> We took a short cut, which is why it smells. Yes, there is technical debt.
>
> Can you use th... - 03:04 AM Conversion Tools Feature #6237: OEUnit support
- Greg Shah wrote:
> Tomasz: Please see #6237-30 for a possible regression from the recent @SourceNameMapper@ changes.... - 04:52 PM Conversion Tools Feature #6320: sharded schemata
- One customer that uses this feature extensively organizes all activity in apps (each one like an independent module)....
- 03:38 PM Database Bug #6699: TemporaryBuffer$Multiplexer memory leak in global block
- Constantin Asofiei wrote:
> Eric: do you recall if the @global@ parameter at the @TemporaryBuffer.define@ is used ... - 02:14 PM Database Bug #6699: TemporaryBuffer$Multiplexer memory leak in global block
- For a very long-running FWD context, there is an accumulation of @TemporaryBuffer$Multiplexer@ instances in the @fina...
- 02:11 PM Database Bug #6699 (WIP): TemporaryBuffer$Multiplexer memory leak in global block
- 03:36 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Ported the following UDFs: ...
- 03:01 PM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching
- Alexandru, I had missed your description of the tracing in #6695-11 when I posted my note.
If the hit/miss counts ... - 02:50 PM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching
- Alexandru Lungu wrote:
> I locally added JMX beans for cache hits and misses and I get the same results (@4.99@ on @... - 10:24 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching
- Greg Shah wrote:
> Make sure that the 4GL code is compiled before you run it. Otherwise the compilation cost in the... - 09:52 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching
- Greg Shah wrote:
> > I locally added JMX beans for cache hits and misses and I get the same results (4.99 on PRESELE... - 09:50 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching
- Yes, no problem.
- 09:45 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching
- Greg Shah wrote:
> Igor: Please add details to [[p2j:JMX Instrumentation]] to allow the rest of the team to easily f... - 09:41 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching
- > I locally added JMX beans for cache hits and misses and I get the same results (4.99 on PRESELECT NO-UNDO, 0.0 on @...
- 09:28 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching
- I locally added JMX beans for cache hits and misses and I get the same results (@4.99@ on @PRESELECT NO-UNDO@, @0.0 o...
- 06:47 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching
- > > I also instrumented FWD with the attached patch (based on 3821c/14190),
>
> Forgot to attach the patch. This m... - 05:33 AM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching
- These are some very insightful results!
@0.499@ rate for @PRESELECT NO-UNDO@ is exactly what I expected: only the ... - 10:46 AM Database Support #6679: H2 general performance tuning
- Dănuț Filimon wrote:
> I ran a test on the sql statements obtained from the Hotel GUI application.
>
> The prepar... - 08:32 AM Database Support #6679: H2 general performance tuning
- I ran a test on the sql statements obtained from the Hotel GUI application.
The prepared statements obtained from ... - 10:24 AM Database Feature #6348: implement support for MariaDB
- The Hotel GUI project is broken, when running @./prepare_hotel.sh@ on a fresh checkout (interestingly, running again ...
08/23/2022
- 06:32 PM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching
- Eric Faulhaber wrote:
> I also instrumented FWD with the attached patch (based on 3821c/14190),
Forgot to attac... - 06:25 PM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching
- I wanted to see where the time was being spent in both the @PreselectQuery@ case and the @CompoundQuery@ case. I also...
- 12:25 PM Database Feature #6695: Multi-table preselect query may underperform due to repetitive fetching
- There is a case in which the multi-table @PreselectQuery@ works slower than a @CompoundQuery@:...
- 12:18 PM Database Feature #6695 (Review): Multi-table preselect query may underperform due to repetitive fetching
- 05:26 PM Conversion Tools Feature #6237: OEUnit support
- We took a short cut, which is why it smells. Yes, there is technical debt.
Can you use the version from rev 14184... - 05:22 PM Conversion Tools Feature #6237: OEUnit support
- Greg Shah wrote:
> We create the @name_map.xml@ during annotations. We used to store the data in a binary serialize... - 05:07 PM Conversion Tools Feature #6237: OEUnit support
- We create the @name_map.xml@ during annotations. We used to store the data in a binary serialized object called @nam...
- 04:47 PM Conversion Tools Feature #6237: OEUnit support
- Greg Shah wrote:
> It is very unlikely that this is unrelated. It may just be an additional regression since @Sourc... - 04:45 PM Conversion Tools Feature #6237: OEUnit support
- Tomasz: Please see #6237-30 for a possible regression from the recent @SourceNameMapper@ changes.
- 04:43 PM Conversion Tools Feature #6237: OEUnit support
- It is very unlikely that this is unrelated. It may just be an additional regression since @SourceNameMapper@ is used...
- 04:41 PM Conversion Tools Feature #6237: OEUnit support
- Greg Shah wrote:
> Let's not spend time on conversion of OEUnit. We know we are not going to use it in FWD.
>
> ... - 03:16 PM Conversion Tools Feature #6237: OEUnit support
- Let's not spend time on conversion of OEUnit. We know we are not going to use it in FWD.
> First, I see warnings ... - 02:54 PM Conversion Tools Feature #6237: OEUnit support
- I cannot compile 3 base OEUnit classes.
First, I see warnings like these:... - 11:52 AM Conversion Tools Feature #6237: OEUnit support
- Constantin Asofiei wrote:
> Vladimir, please create a 4GL package for the class - I think FWD has problems convertin... - 06:17 AM Conversion Tools Feature #6237: OEUnit support
- Vladimir Tsichevski wrote:
> Greg Shah wrote:
> > I don't object to the change, but we don't want to spent time on ... - 06:07 AM Conversion Tools Feature #6237: OEUnit support
- Greg Shah wrote:
> I don't object to the change, but we don't want to spent time on making external files work at th... - 03:15 AM Conversion Tools Feature #6237: OEUnit support
- Vladimir, please create a 4GL package for the class - I think FWD has problems converting .cls files without a packag...
- 02:30 PM Database Bug #6275: SKIP-DELETED-RECORD implementation
- > A single question: calls to @stopOnSkippedRecord@ occur on @first@, @next@, and @previous@ navigation. Shouldn't th...
- 01:55 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Ported the following UDFs: ...
- 12:34 PM Database Feature #6582: implement multi-table AdaptiveQuery
- > I should note that in a real application, it would be very unusual to have a wide open cross join like this, which ...
- 11:10 AM Database Feature #6582: implement multi-table AdaptiveQuery
- Alexandru Lungu wrote:
> > I am facing a three times slower query in @AdaptiveQuery@ comparing to @CompoundQuery@ (a... - 08:22 AM Runtime Infrastructure Support #5567: move FWD to Java 11
- Greg Shah wrote:
> OK, so far this looks like it is consistent with the customer's early findings (i.e. Java 8 is 10... - 04:45 AM Database Support #6679: H2 general performance tuning
- Committed 3821c/rev.14187 where I replaced @.nextvalue@ with @next value for@ in order to prepare for the 2.1.210 H2 ...
- 03:52 AM Database Support #6679: H2 general performance tuning
- Eric Faulhaber wrote:
> What is currently calling .nextval?
@P2JH2Dialect.getSequencePrefetchString()@, @FastCopy... - 01:56 AM Base Language Bug #6693: StringFormat fixes - finish up and merge branch 4880a|b|c
- Although the main fix for a @<complex_gui_application>@ is done (see #4880), a lot of improvements have already been ...
- 01:52 AM Base Language Bug #6693 (New): StringFormat fixes - finish up and merge branch 4880a|b|c
08/22/2022
- 07:46 PM Conversion Tools Feature #6237: OEUnit support
- I don't object to the change, but we don't want to spent time on making external files work at this time. We have ma...
- 07:03 PM Conversion Tools Feature #6237: OEUnit support
- Got a classic error when compiling OEUnit: @FileNotFoundException@ when a propath has an entry outside the project su...
- 06:46 PM Conversion Tools Feature #6237: OEUnit support
- Greg Shah wrote:
> > > In list mode, you may only have a portion of the dependencies in the object graph. That will... - 06:22 PM Conversion Tools Feature #6237: OEUnit support
- > > In list mode, you may only have a portion of the dependencies in the object graph. That will fail. In non-list ...
- 05:34 PM Conversion Tools Feature #6237: OEUnit support
- Greg Shah wrote:
> In list mode, you may only have a portion of the dependencies in the object graph. That will fai... - 05:22 PM Conversion Tools Feature #6237: OEUnit support
- In list mode, you may only have a portion of the dependencies in the object graph. That will fail. In non-list mode...
- 05:07 PM Conversion Tools Feature #6237: OEUnit support
- Greg Shah wrote:
> > # this does not help
> > # the skeleton is located outside of @testcases@ either, but classe... - 04:54 PM Conversion Tools Feature #6237: OEUnit support
- Vladimir Tsichevski wrote:
> Greg Shah wrote:
> > Pointing to a skeletons directory outside of your project root ma... - 04:43 PM Conversion Tools Feature #6237: OEUnit support
- Classes can be converted by @ant convert@, but by @ant convert.list@.
- 04:30 PM Conversion Tools Feature #6237: OEUnit support
- Greg Shah wrote:
> Pointing to a skeletons directory outside of your project root may be causing the issue or at lea... - 04:25 PM Conversion Tools Feature #6237: OEUnit support
- Pointing to a skeletons directory outside of your project root may be causing the issue or at least an issue. The sk...
- 04:23 PM Conversion Tools Feature #6237: OEUnit support
- Greg Shah wrote:
> Is your current directory @/home/vvt/Projects/@? In other words, your conversion project top-lev... - 04:20 PM Conversion Tools Feature #6237: OEUnit support
- Is your current directory @/home/vvt/Projects/@? In other words, your conversion project top-level directory is @/ho...
- 04:17 PM Conversion Tools Feature #6237: OEUnit support
- Greg Shah wrote:
> Are you working with the new testcases project ([[p2j:Testcases]])? This is already configured p... - 04:10 PM Conversion Tools Feature #6237: OEUnit support
- Are you working with the new testcases project ([[p2j:Testcases]])? This is already configured properly to convert O...
- 03:55 PM Conversion Tools Feature #6237: OEUnit support
- Greg Shah wrote:
> > I want to convert OEUnit 4gl sources
>
> Are you trying to convert OEUnit itself?
In genera... - 04:11 PM Base Language Bug #6640: parsing bug for initial ",0000" for decimal variables or fields
- > Also, we need to check if this must be configured in p2j.cfg.xml or not (i.e. if it must consider -numsep at the 4G...
- 03:42 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Ported matches, matcheslist, lookup.
Committed to 3821c/14184. - 01:35 PM Runtime Infrastructure Feature #6692: move FWD to Java 17
- "Java 17 Release Notes":https://www.oracle.com/java/technologies/javase/17-relnotes.html
"Java 17 Features":https://... - 01:27 PM Runtime Infrastructure Feature #6692 (Test): move FWD to Java 17
- 01:25 PM Runtime Infrastructure Support #5567: move FWD to Java 11
- OK, so far this looks like it is consistent with the customer's early findings (i.e. Java 8 is 10-20% faster than Jav...
- 11:49 AM Runtime Infrastructure Support #5567: move FWD to Java 11
- Rebased to 3821c/14173, pushed 5567a/14191 for performance comparison tests.
- 11:48 AM Runtime Infrastructure Support #5567: move FWD to Java 11
- Greg Shah wrote:
> Let me know when you have some results on the performance comparison. I think that is the remain... - 11:22 AM Database Support #6679: H2 general performance tuning
- Dănuț Filimon wrote:
> Regarding the syntax difference about nextval in #6679-11.
>
> Since we can't use @.nextva... - 10:09 AM Database Support #6679: H2 general performance tuning
- Regarding the syntax difference about nextval in #6679-11.
Since we can't use @.nextval@ in version 2.1.210 of H2,... - 10:38 AM Database Feature #6582: implement multi-table AdaptiveQuery
- > I am facing a three times slower query in @AdaptiveQuery@ comparing to @CompoundQuery@ (a read-only example). This ...
- 08:40 AM Database Feature #6348: implement support for MariaDB
- > The dialect generates now string columns as varchar(100). I did not push the system intentionally, but with the scr...
08/20/2022
- 07:45 AM Database Feature #6582: implement multi-table AdaptiveQuery
- Eric Faulhaber wrote:
> Alexandru Lungu wrote:
>> Initially, I expect to see the AdaptiveQuery working out-of-the-b... - 06:42 AM Database Support #6679: H2 general performance tuning
- > OTOH, I am a bit concerned that the performance drops off again in versions >210. Does the H2 history log suggest t...
- 09:22 PM Database Feature #6348: implement support for MariaDB
- Committed revision 14182.
Eric Faulhaber wrote:
> Any update on the status of running Hotel GUI with MariaDB?
Th...
08/19/2022
- 03:47 PM Database Support #6679: H2 general performance tuning
- Alexandru, I'll leave it to you to set the assignee. If both gentlemen are working on this task, you can leave it bla...
- 03:39 PM Database Support #6679 (WIP): H2 general performance tuning
- The fact that there are so many transactions being executed in the tests actually is encouraging to me. Since transac...
- 03:17 PM Database Support #6679: H2 general performance tuning
- Around 20 transactions are done by one user per iteration. There are 200 users per tests (except one test with 10 use...
- 10:58 AM Database Support #6679: H2 general performance tuning
- Just curious: do the tests use a lot of transactions? This is where we have seen a serious bottleneck in the past.
- 10:13 AM Database Support #6679: H2 general performance tuning
- I tested version 210 patched with the Hotel_GUI application and there were no major problems, except a syntax differe...
- 08:28 AM Database Support #6679: H2 general performance tuning
- > Yes, the tests for 1.4.200 patched use PageStore and the later versions use MVStore.
Fantastic! I think it is f... - 05:26 AM Database Support #6679: H2 general performance tuning
- Greg Shah wrote:
> Are the above comparisons using 1.4.200 patched in PageStore mode versus the later versions in mv... - 03:28 PM Conversion Tools Feature #6237: OEUnit support
- > I want to convert OEUnit 4gl sources
Are you trying to convert OEUnit itself? There is likely to be code in the... - 03:22 PM Conversion Tools Feature #6237: OEUnit support
- There's something else wrong with your config:...
- 03:06 PM Conversion Tools Feature #6237: OEUnit support
- Constantin Asofiei wrote:
> You need to add the skeleton project in cfg/p2j.cfg.xml via:
> [...]
Skeleton source... - 02:52 PM Conversion Tools Feature #6237: OEUnit support
- You need to add the skeleton project in cfg/p2j.cfg.xml via:...
- 02:41 PM Conversion Tools Feature #6237 (WIP): OEUnit support
- I want to convert @OEUnit@ 4gl sources, and I do not know how to convert 4gl classes with FWD. I think, I miss someth...
- 03:00 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Eric Faulhaber wrote:
> According to https://dev.mysql.com/doc/refman/8.0/en/signal.html, using SIGNAL with a SQLSTA... - 02:54 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- According to https://dev.mysql.com/doc/refman/8.0/en/signal.html, using SIGNAL with a SQLSTATE which begins with @01@...
- 01:58 PM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Does anybody know a replacement of PostgreSQL @RAISE NOTICE@ statement for MariaDB?
I've used it for debugging compl... - 11:40 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Update.
Here is the complete list of MariaDB UDFs to be implemented:... - 11:27 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- Eric Faulhaber wrote:
> What is the revised total number of UDFs for this dialect, and how many currently have a fir... - 09:58 AM Database Feature #6628: port PostgreSQL native user defined functions to MariaDB
- What is the revised total number of UDFs for this dialect, and how many currently have a first pass implementation? I...
- 03:00 PM Database Feature #6348: implement support for MariaDB
- Ovidiu Maxiniuc wrote:
> My attempt to add a new guest caused a @Guest Accommodation Report@ with 225 entries (eve... - 11:37 AM Database Feature #6348: implement support for MariaDB
- Now that you are working with Hotel GUI (i.e., something that, while not a "real" application, is more than a simple ...
- 09:49 AM Database Feature #6348: implement support for MariaDB
- Ovidiu Maxiniuc wrote:
> With hotel_gui/r248 and 3821c/14168, I am able to start the client and authenticate. The @G... - 10:36 AM Database Feature #6582: implement multi-table AdaptiveQuery
- Alexandru Lungu wrote:
> Initially, I expect to see the @AdaptiveQuery@ working out-of-the-box with the current im... - 07:55 AM Database Bug #6688: ASSIGN trigger conversion when field has DECIMALS clause
- Ovidiu Maxiniuc wrote:
> With 3821c your testcases correctly converts to
> [...]
>
> This was fixed recently r1... - 07:54 AM Database Bug #6688: ASSIGN trigger conversion when field has DECIMALS clause
- With 3821c your testcases correctly converts to ...
- 03:33 AM Database Bug #6688: ASSIGN trigger conversion when field has DECIMALS clause
- There is a problem when converting a runtime ASSIGN database trigger, with a field having DECIMALS and/or INITIAL cla...
- 03:31 AM Database Bug #6688 (Closed): ASSIGN trigger conversion when field has DECIMALS clause
Also available in: Atom