FWD » Core Development » Database

09/29/2022

04:27 PM Feature #6371: implement SAVE CACHE statement

I pushed several fixes for the comments above:
* SchemaComparator file access synchronization
* ClassLoader del... Boris Schegolev

10:51 AM Feature #6371: implement SAVE CACHE statement

Boris Schegolev wrote:
> BTW, what database are you connected to? MySQL, Postgres, ...?
So far, I've only tested ... Eric Faulhaber

06:37 AM Feature #6371: implement SAVE CACHE statement

I pushed a fix for the NPE as revision 14108.
As for the flow, the intended use goes like this:
# @saveInitialS... Boris Schegolev

04:28 AM Feature #6371: implement SAVE CACHE statement

BTW, what database are you connected to? MySQL, Postgres, ...? Boris Schegolev

04:24 AM Feature #6371: implement SAVE CACHE statement

Eric Faulhaber wrote:
> The problem is that we are trying to get all index info for all tables, but that API doesn... Boris Schegolev

02:28 AM Feature #6371: implement SAVE CACHE statement

I've made changes to @SchemaComparator@, mostly formatting to match our coding standards, and some functional to get ... Eric Faulhaber

03:52 PM 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 t... Greg Shah

08:24 AM Feature #6582: implement multi-table AdaptiveQuery

> either the conversion should generate multi-table AdaptiveQuery only for persistent tables
I think we should be... Greg Shah

08:20 AM Feature #6582: implement multi-table AdaptiveQuery

Are all of the tests written for this in 4GL code? Can the testing be easily replicated by others in the future? I'... Greg Shah

06:07 AM Feature #6582: implement multi-table AdaptiveQuery

I've done some tests with H2 2.1.214 an there is no improvement with the query plan (especially for cross joins).
... Alexandru Lungu

09/28/2022

05:53 PM Feature #6371: implement SAVE CACHE statement

FYI, I am making major changes to @SchemaComparator@. Please do not modify this class until I check it in. Eric Faulhaber

02:06 AM Feature #6371: implement SAVE CACHE statement

I reverted rev 14106 locally because it breaks the singleton contract of @AsmClassLoader@ and thus breaks server star... Eric Faulhaber

07:11 AM Feature #6582: implement multi-table AdaptiveQuery

|_\13. Iterate all records with NEXT |
|_\2. Test |_\2. 4GL temporary ... Alexandru Lungu

09/27/2022

12:35 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Eric Faulhaber wrote:
> Igor, how did you ultimately deal with the error handler (@initError@, @checkError@, etc.)? ... Igor Skornyakov

11:17 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Igor, how did you ultimately deal with the error handler (@initError@, @checkError@, etc.)? Do any test cases in your... Eric Faulhaber

09:45 AM Feature #6582: implement multi-table AdaptiveQuery

I updated the table from #6582-33 with 8 new multi-table queries which are often used in large applications:
* *rang... Alexandru Lungu

09/26/2022

03:03 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Testing MariaDB UDFs with UNKNOWN arguments/values, finished.
Committed to 6129a/14414 (except @where_clause_pre_p... Igor Skornyakov

08:05 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Nice catch!
The fix from #6628-153 should be enough. When HQL/FQL are parsed, the LPARENS of the functions are drop... Ovidiu Maxiniuc

09/24/2022

05:30 AM Feature #6582: implement multi-table AdaptiveQuery

|_\13. Iterate all records with NEXT |
|_\2. Test |_\2. 4GL temporary ... Alexandru Lungu

09/23/2022

02:24 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

That if end of the switch is... Igor Skornyakov

02:07 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Eric Faulhaber wrote:
> You need the data type of an argument to a UDF, where the argument itself is a UDF, correct?... Igor Skornyakov

01:47 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

You need the data type of an argument to a UDF, where the argument itself is a UDF, correct?
Two questions:
* L... Eric Faulhaber

01:24 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Eric Faulhaber wrote:
> Wouldn't
>
> [...]
>
> be more reliable?
@case FUNCTION@ already exists. Igor Skornyakov

01:03 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Wouldn't... Eric Faulhaber

12:58 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Igor Skornyakov wrote:
> I've temporary restored rev. 13138 changes to @where_clause_pre_prep.rules@ to run compatib... Igor Skornyakov

11:11 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

I've temporary restored rev. 13138 changes to @where_clause_pre_prep.rules@ to run compatibility tests with nullable ... Igor Skornyakov

01:34 PM Feature #6371: implement SAVE CACHE statement

I implemented class unloading through delegates as was suggested in TODO in @AsmClassLoader@.
The code is in 6371a... Boris Schegolev

09:48 AM Support #6713: check if it is faster to use separate temp-table instances instead of multiplex id

I made a set of tests for multiplex and no-multiplex using indexes.
The tests have the following specifications:
... Dănuț Filimon

09/22/2022

03:31 PM Feature #6371: implement SAVE CACHE statement

Eric Faulhaber wrote:
> the @ClassLoader@ itself had to be garbage collected
That is correct. We can re-instantia... Boris Schegolev

03:26 PM Feature #6371: implement SAVE CACHE statement

Boris Schegolev wrote:
> Class unloading is done (unless I missed something). Unloading the class from JVM itself is... Eric Faulhaber

03:16 PM Feature #6371: implement SAVE CACHE statement

Class unloading is done (unless I missed something). Unloading the class from JVM itself is only done by the Garbage ... Boris Schegolev

11:05 AM Bug #6767: Possible name clashes in DMO classes

Here is the list of matching by name methods:... Vladimir Tsichevski

10:16 AM Bug #6767: Possible name clashes in DMO classes

Eric Faulhaber wrote:
> To clarify the task, we need to work through all superinterfaces of the @persist.Buffer@ int... Vladimir Tsichevski

10:11 AM Feature #6582: implement multi-table AdaptiveQuery

I've done the same tests for persistent tables and updated #6582-30.
For persistent tables, multi-table @AdaptiveQue... Alexandru Lungu

09/21/2022

02:01 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Fixed trimming UDFs string arguments for MariaDB.
Committed to 6191a/14412.
All compatibility tests except ones h... Igor Skornyakov

10:50 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Greg Shah wrote:
> Isn't this just a consequence of the (currently) broken compatibility of using varchar as a datat... Igor Skornyakov

10:41 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Isn't this just a consequence of the (currently) broken compatibility of using varchar as a datatype for MariaDB? Greg Shah

10:39 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

I've experienced the #4551-310 again (the compatibility test for @lengthof@ fails because of the argument trimming).... Igor Skornyakov

12:11 PM Feature #6457: finish COPY-LOB support

Stanislav Lomany wrote:
> Do you have any idea what and how 4GL produces?
Try launching the 4GL using @-cpinternal ... Ovidiu Maxiniuc

01:45 AM Feature #6457: finish COPY-LOB support

Stanislav, looking at the @14844588@ value, in hex is e282ac. See this: https://community.progress.com/s/article/P18... Constantin Asofiei

11:10 AM Feature #6582: implement multi-table AdaptiveQuery

I've prepared a consistent set of tests, but it seems only some are actually finished in a reasonable time.
|_\2. ... Alexandru Lungu

04:25 AM Feature #6582: implement multi-table AdaptiveQuery

I am close to an end with #6582-27. Only some use cases are left to clear off. Note that I updated #6582-27 to reflec... Alexandru Lungu

09/20/2022

07:24 PM Feature #6457 (WIP): finish COPY-LOB support

Guys, I don't quite understand how 4GL produces output. Consider the following UTF-16 output example:... Stanislav Lomany

04:21 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Greg Shah wrote:
> It would be best to avoid such code in our testcases. If you really need something platform spec... Igor Skornyakov

03:56 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

It would be best to avoid such code in our testcases. If you really need something platform specific, then have a ve... Greg Shah

03:30 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Ovidiu Maxiniuc wrote:
> Set the OS of the sources in @cfg/p2j.cfg.xml@:
> [...]or[...]
Thank you, Ovidiu.
It h... Igor Skornyakov

03:25 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Set the OS of the sources in @cfg/p2j.cfg.xml@:... Ovidiu Maxiniuc

12:54 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Ovidiu Maxiniuc wrote:
> Igor Skornyakov wrote:
> > A string literal @'a1b123*\{}()1'@ is converted to @new charact... Igor Skornyakov

12:38 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Igor Skornyakov wrote:
> A string literal @'a1b123*\{}()1'@ is converted to @new character("a1b123*{}()1")@. What I'... Ovidiu Maxiniuc

05:44 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

The compatibility test for @matches@ fails for a strange reason.
A string literal @'a1b123*\{}()1'@ is converted to ... Igor Skornyakov

03:50 PM Feature #6371: implement SAVE CACHE statement

I got rid of TODOs in the code and followed some of suggestions above (naming). The new code now only has a TODO for ... Boris Schegolev

11:29 AM Feature #6582: implement multi-table AdaptiveQuery

What can you see in terms of the impact of this refactoring on performance so far, if anything? Eric Faulhaber

09/19/2022

06:43 PM Bug #6767: Possible name clashes in DMO classes

To clarify the task, we need to work through all superinterfaces of the @persist.Buffer@ interface, along with all th... Eric Faulhaber

09:03 AM Bug #6767: Possible name clashes in DMO classes

In DMO classes, getter and setter names are created automatically by conversion, based on the field names which are a... Vladimir Tsichevski

08:12 AM Bug #6767 (Review): Possible name clashes in DMO classes

Vladimir Tsichevski

03:15 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Fixed injection of session attributes' values into UDF calls for MariaDB.
Committed to 6129a/14407. Igor Skornyakov

03:09 PM Bug #6703: loading schema table DMO interface with no defined fields

Ovidiu Maxiniuc wrote:
> Constantin, I reviewed it and your fix in 6129a/14273 seems logical.
>
> I also added tw... Eric Faulhaber

09/18/2022

05:32 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

More about collation.
At this moment @import.db@ creates MariaDB database with @DEFAULT CHARACTER SET utf8mb4 DEFAUL... Igor Skornyakov

09/17/2022

09:04 AM 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... Constantin Asofiei

09:02 AM Bug #6766 (WIP): before-table options not inherited from the after-table (like NO-UNDO, SHARED, etc)

Constantin Asofiei

05:22 AM 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... Igor Skornyakov

09:40 PM Feature #6348: implement support for MariaDB

I have committed r14399/6129a. It contains improved compatibility for sorting NULL high for MariaDb.
Note that, Mari... Ovidiu Maxiniuc

09/16/2022

05:30 PM 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... Ovidiu Maxiniuc

11:09 AM 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... Igor Skornyakov

10:59 AM 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... Igor Skornyakov

05:15 AM 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. ... Igor Skornyakov

04:48 AM 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... Igor Skornyakov

09:48 AM 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... Dănuț Filimon

08:36 AM Feature #6418: represent extent fields as arrays

The above is my opinion. Eric makes the final decision here. Greg Shah

08:36 AM 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... Greg Shah

05:16 AM 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 ... Radu Apetrii

05:12 AM Feature #6695 (WIP): Multi-table preselect query may underperform due to repetitive fetching

Alexandru Lungu

02:26 AM Feature #6371: implement SAVE CACHE statement

Boris Schegolev wrote:
> In the latest version (6371a/14102) I removed dependency on @DynamicTablesHelper@ completel... Eric Faulhaber

09/15/2022

05:21 PM 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... Igor Skornyakov

05:23 AM 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]@ ... Igor Skornyakov

05:01 AM 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:... Igor Skornyakov

04:21 AM 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... Igor Skornyakov

03:43 AM 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... Igor Skornyakov

04:55 PM 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... Ovidiu Maxiniuc

04:22 PM Feature #6371: implement SAVE CACHE statement

In the latest version (6371a/14102) I removed dependency on @DynamicTablesHelper@ completely. The code compiles, but ... Boris Schegolev

01:24 PM Bug #6699 (WIP): TemporaryBuffer$Multiplexer memory leak in global block

There is still a leak in the @TransactionManager$WorkArea.globalBlock.finalizables@. Constantin Asofiei

07:54 AM Feature #6763 (Rejected): implement configurable sizes (in the directory) for FastFindCache and O...

Greg Shah

09/14/2022

03:33 PM 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... Igor Skornyakov

03:29 PM 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... Ovidiu Maxiniuc

02:35 PM 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 ... Igor Skornyakov

05:08 AM 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... Igor Skornyakov

11:29 AM 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... Alexandru Lungu

11:12 AM 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... Alexandru Lungu

09/13/2022

07:27 PM 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... Stanislav Lomany

07:04 AM Feature #6457: finish COPY-LOB support

The BOM handling has a testcase already written. See @testcases/copy_lob/tests/bom.p@. Greg Shah

01:49 PM 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... Eric Faulhaber

01:27 PM 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... Ovidiu Maxiniuc

01:38 AM Feature #6371: implement SAVE CACHE statement

Boris Schegolev wrote:
> I updated @DatabaseManager@ to handle registration of the new interface.
I didn't really... Eric Faulhaber

01:16 PM 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... Alexandru Lungu

10:30 AM 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... Igor Skornyakov

10:09 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Any issues coming out of testing? Any headway on the error handling solution? Thanks. Eric Faulhaber

10:16 AM Feature #6453 (WIP): temp-table features

Eric Faulhaber

09/12/2022

04:05 PM 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... Boris Schegolev

12:27 PM 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... Greg Shah

08:39 AM 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... Greg Shah

08:35 AM 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... Alexandru Lungu

05:44 AM 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... Greg Shah

05:24 AM 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 ... Dănuț Filimon

10:10 AM 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... Igor Skornyakov

06:11 AM Feature #6348: implement support for MariaDB

Igor Skornyakov wrote:
> It looks that we need to use @timestamp(3)@/@datetime(3)@ instead of @timestamp@/@datetime@... Ovidiu Maxiniuc

05:07 AM Feature #6453: temp-table features

6129a Greg Shah

04:53 AM Feature #6453: temp-table features

Ovidiu,
Which branch should I use for this task?
Thank you. Igor Skornyakov

09/09/2022

12:13 PM 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... Constantin Asofiei

12:08 PM Bug #6744 (New): rollback when there are catch/finally blocks opening their own transactions

Constantin Asofiei

12:08 PM Feature #6453: temp-table features

Ovidiu Maxiniuc wrote:
> Igor, I think @PRIMARY@ has already been implemented in branch 6129a. I think that is your ... Igor Skornyakov

12:06 PM 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... Ovidiu Maxiniuc

12:30 AM Feature #6453: temp-table features

Igor, please see #6453-3 and ask Ovidiu any questions you have. Eric Faulhaber

12:05 PM Bug #6699 (Review): TemporaryBuffer$Multiplexer memory leak in global block

The fix for this is in #6641-34, 6129a rev 14388. Constantin Asofiei

10:19 AM 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... Constantin Asofiei

10:19 AM 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:
> [... Eric Faulhaber

05:49 AM Bug #6699: TemporaryBuffer$Multiplexer memory leak in global block

I think I have a better fix for this leak; in @TemporaryBuffer.initialize@ do this:... Constantin Asofiei

10:17 AM Feature #6582: implement multi-table AdaptiveQuery

I started using the tests from @uast/adaptive_scrolling@ to test the changes for multi-table @AdaptiveQuery@. Almost ... Alexandru Lungu

06:05 AM 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... Radu Apetrii

04:51 AM 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... Igor Skornyakov

01:43 AM Bug #6741: Word index support for MariaDB.

Implement word index support for MariaDB using word tables Igor Skornyakov

01:41 AM Bug #6741 (New): Word index support for MariaDB.

Igor Skornyakov

01:40 AM 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... Igor Skornyakov

12:46 AM 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... Eric Faulhaber

12:23 AM 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.... Eric Faulhaber

11:01 PM 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... Eric Faulhaber

09/08/2022

07:24 PM 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:
* @... Ovidiu Maxiniuc

09/07/2022

04:16 PM 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... Ovidiu Maxiniuc

03:52 PM 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... Eric Faulhaber

01:52 PM 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... Ovidiu Maxiniuc

02:58 PM 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... Igor Skornyakov

09:43 AM 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... Radu Apetrii

09:25 AM 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... Dănuț Filimon

02:09 AM 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 ... Dănuț Filimon

09/06/2022

02:34 PM 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... Eric Faulhaber

10:15 AM 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... Eric Faulhaber

09:56 AM 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... Dănuț Filimon

11:26 AM Feature #6582: implement multi-table AdaptiveQuery

Alexandru Lungu wrote:
in my mind, the "dynamic mode" is still initially represented by the CompundQuery b... Alexandru Lungu

11:24 AM Feature #6695: Multi-table preselect query may underperform due to repetitive fetching

- removed the comment -
It was meant to be posted in #6582 Alexandru Lungu

09/05/2022

04:21 PM Feature #6371: implement SAVE CACHE statement

It is not ideal to use @DynamicTablesHelper@ (in its current form) to create persistent table DMO interfaces/classes.... Eric Faulhaber

03:47 PM Support #6679: H2 general performance tuning

Alexandru Lungu wrote:
> [...]
Thank you for the explanation.
> I will update Performance_Testing_the_H2_Datab... Eric Faulhaber

12:12 PM 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 ... Alexandru Lungu

10:31 AM 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... Eric Faulhaber

09:46 AM 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.... Dănuț Filimon

02:22 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Ported the following UDF: ... Igor Skornyakov

03:55 AM 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 ... Igor Skornyakov

04:28 AM 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... Greg Shah

02:58 AM 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... Radu Apetrii

01:57 AM 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... Greg Shah

09/02/2022

02:14 PM 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 ... Eric Faulhaber

01:03 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Ported the following UDFs: ... Igor Skornyakov

04:06 AM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Ported the following UDFs: ... Igor Skornyakov

10:26 AM 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 ... Eric Faulhaber

09:46 AM 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... Dănuț Filimon

09:07 AM Feature #6418 (WIP): represent extent fields as arrays

Alexandru Lungu

09:06 AM Support #6713 (WIP): check if it is faster to use separate temp-table instances instead of multip...

Alexandru Lungu

02:47 AM 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... Stefan Brands

09/01/2022

03:59 PM 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.... Eric Faulhaber

08/31/2022

02:50 PM Feature #6628: port PostgreSQL native user defined functions to MariaDB

Ported the following UDFs: ... Igor Skornyakov

09:33 AM 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 ... Constantin Asofiei

09:30 AM Feature #6729 (New): improve database and temp-table toString to write all records without relyin...

Constantin Asofiei