FWD » Core Development » Database

03/28/2023

11:34 PM Feature #6444: dataset improvements

Review of 6444a/14538:
* @AbstractQuery.java@, @CompoundComponent.java@, Dialect.java, etc: GCD coding standard: ple... Ovidiu Maxiniuc

03/27/2023

10:29 AM Bug #7220: Record not created when property is set to empty string

I remember that Danut also tested the example with a temporary table. In that case, the record was found because @isA... Alexandru Lungu

03/24/2023

06:56 PM Feature #6371: implement SAVE CACHE statement

I puhsed revision 6371b/14487. It provides support for DTTZ columns, fixes for MariaDB in @SchemaCheck@ and support f... Boris Schegolev

03/23/2023

04:27 AM Feature #7061 (Test): Enable the use of lazy result sets in H2

Alexandru Lungu

04:25 AM Bug #7165 (Test): Close multiplex scope using prepared statement

Alexandru Lungu

10:49 PM Bug #7220: Record not created when property is set to empty string

Interesting finding.
The record is not forced to flush to DB when it was created. The 'touch' marks the field as d... Ovidiu Maxiniuc

03/22/2023

07:18 AM Bug #7220: Record not created when property is set to empty string

Found an issue related to persistent tables where a record is not created when the property is set to an empty string... Dănuț Filimon

07:10 AM Bug #7220 (New): Record not created when property is set to empty string

Dănuț Filimon

06:34 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns

When I added rtrimming to H2, I set it so that it will always rtrim when comparing strings. Then I noticed an issue d... Dănuț Filimon

03/20/2023

01:30 PM Bug #7211: Several H2 connections for one single session

-Adding a server log that contains around 100 of such connections. Note that is just during server startup without th... Thanasis Giannakopoulos

09:54 AM Feature #7062: Direct access to H2 internals to solve basic queries

I also committed an optimization for #7062-27 (7062b_h2/rev. 14 and 7026b/rev. 14512), including a mean of lazily com... Alexandru Lungu

03/17/2023

08:48 AM Feature #7062: Direct access to H2 internals to solve basic queries

Created 7062b_h2 for further work on H2.
Committed 7062b_h2/rev. 13 - generating a dummy jdbc statement for each r... Alexandru Lungu

06:30 AM Feature #6444: dataset improvements

Please don't. They will get forgotten. Marian has already confirmed he will handle the merge. Greg Shah

06:15 AM Feature #6444: dataset improvements

Greg Shah wrote:
> Marian/Constantin: Can you recommend a better place for these tests than @6453-6444/@?
>
> Igo... Igor Skornyakov

06:11 AM Feature #6444: dataset improvements

Marian/Constantin: Can you recommend a better place for these tests than @6453-6444/@?
Igor: We don't want to stor... Greg Shah

05:49 AM Feature #6444: dataset improvements

Tests for #6453 and #6444 has been added to @6453-6444@ subfolder of the @xfer.goldencode.com/opt/testcases/@ rev. 13... Igor Skornyakov

04:14 AM Feature #6444: dataset improvements

Marian Edu wrote:
> Igor, I think the easiest way to do that is to simply use a 'pipe through' routine - I think we ... Igor Skornyakov

03:16 AM Feature #6444: dataset improvements

Igor Skornyakov wrote:
> This is for testing TEMP-TABLEs DATA-SETs as arguments in the remote calls.
Igor, I th... Marian Edu

03:12 AM Feature #6444: dataset improvements

Greg Shah wrote:
> Marian: Do you want Igor to commit his tests into the current [[p2j:Testcases]] or do you want so... Marian Edu

03:09 AM Feature #6444: dataset improvements

Greg Shah wrote:
> Marian: Has your team had to do this with the existing tests?
We've followed a similar approac... Marian Edu

05:51 AM Bug #5306: AdaptiveQuery sets a found record into the buffer twice in dynamic mode

Radu Apetrii wrote:
> Alexandru Lungu wrote:
> > Can you do a run on the latest rev. 14507?
>
> Since the tests ... Alexandru Lungu

05:07 AM Bug #5306: AdaptiveQuery sets a found record into the buffer twice in dynamic mode

Alexandru Lungu wrote:
> Can you do a run on the latest rev. 14507?
Since the tests were already set up, I ran th... Radu Apetrii

03/16/2023

01:08 PM Feature #6444: dataset improvements

Greg Shah wrote:
> We may want this to be configurable.
>
> Why does it generate output on the server side? That... Igor Skornyakov

12:55 PM Feature #6444: dataset improvements

We may want this to be configurable.
Why does it generate output on the server side? That doesn't sound expected. Greg Shah

12:53 PM Feature #6444: dataset improvements

Please note also that some tests generate files not only in the client home but also in the app. server home. This ma... Igor Skornyakov

12:46 PM Feature #6444: dataset improvements

Greg Shah wrote:
> I agree. It is good to be able to look deeply at any issue. I just want the comparison/detectio... Igor Skornyakov

12:40 PM Feature #6444: dataset improvements

I agree. It is good to be able to look deeply at any issue. I just want the comparison/detection of a problem to be... Greg Shah

12:25 PM Feature #6444: dataset improvements

Please note that my approach for testing is based on visual comparision of multiple output files generated by the tes... Igor Skornyakov

12:08 PM Feature #6444: dataset improvements

Marian: Do you want Igor to commit his tests into the current [[p2j:Testcases]] or do you want some other process to ... Greg Shah

12:06 PM Feature #6444: dataset improvements

Greg Shah wrote:
> Are all of your testcases integrated into the dataset tests in [[p2j:Testcases]]? If not, they s... Igor Skornyakov

12:02 PM Feature #6444: dataset improvements

Are all of your testcases integrated into the dataset tests in [[p2j:Testcases]]? If not, they should be.
Marian'... Greg Shah

10:31 AM Feature #6444 (Review): dataset improvements

Radu Apetrii wrote:
> Igor, I've attached a patch that should solve the problem.
>
> There was a parameter in @Ad... Igor Skornyakov

10:06 AM Feature #6444: dataset improvements

Radu Apetrii wrote:
> Igor, I've attached a patch that should solve the problem.
>
> There was a parameter in @Ad... Igor Skornyakov

09:54 AM Feature #6444: dataset improvements

Igor, I've attached a patch that should solve the problem.
There was a parameter in @AdaptiveQuery.executeScroll@ ... Radu Apetrii

05:41 AM Feature #6444: dataset improvements

Radu Apetrii wrote:
> In @AdaptiveQuery.executeQuery@, due to the introduction of @lazyMode@, all the @ProgressiveRe... Radu Apetrii

05:12 AM Feature #6444: dataset improvements

Eric Faulhaber wrote:
> Radu, have you been able to recreate the problem with branch #6444a?
Yes, I have.
In @Ad... Radu Apetrii

02:14 AM Feature #6444: dataset improvements

Eric Faulhaber wrote:
> Rather than just commenting out the lazy mode code in @AdaptiveQuery@, as in #6444-147, I st... Igor Skornyakov

11:48 PM Feature #6444: dataset improvements

Igor Skornyakov wrote:
> Apart from READ-JSON support and #6444-149 all is done and 6444a is ready for the code re... Eric Faulhaber

11:53 AM Bug #6887: improve performance of dataset/table[-handle] parameters

This is the entire JMX result for the large application:... Constantin Asofiei

02:59 AM Bug #6887: improve performance of dataset/table[-handle] parameters

Boris Schegolev wrote:
> I found a few points where we spend most CPU time:
>
> 1. Reflexive invocation @java.lan... Eric Faulhaber

02:31 AM Bug #6887: improve performance of dataset/table[-handle] parameters

Constantin Asofiei wrote:
> In a large application, there is this JMX reported times (count/millis/nanos):
> ... Eric Faulhaber

11:50 AM Feature #7062: Direct access to H2 internals to solve basic queries

Go with option 2 - on @getStatement()@ call, lazily create the @java.sql.Statement@ instance which has all the entire... Constantin Asofiei

11:31 AM Feature #7062: Direct access to H2 internals to solve basic queries

Response to #7026-97
Constantin Asofiei wrote:
> Alexandru, I'm not sure where to post this. The changes for @Di... Alexandru Lungu

11:16 AM Bug #7211: Several H2 connections for one single session

This is an issue as there are several messages like the following in the server log:... Alexandru Lungu

11:04 AM Bug #7211 (WIP): Several H2 connections for one single session

Alexandru Lungu

10:58 AM Bug #5306: AdaptiveQuery sets a found record into the buffer twice in dynamic mode

Radu, I think you have both 7026b (at least rev. 14505) and the @adaptive_scrolling@ tests (scrolling and non-scrolli... Alexandru Lungu

10:28 AM Feature #7060 (WIP): Consider using wildcard selection to reduce SQL size

I committed 7026b/rev. 14506 for wildcard selection only for P2JH2 dialect which already supports @INVISIBLE@ keyword... Alexandru Lungu

09:34 AM Bug #7185: H2 in-memory lazy hydration

> override checkIncomplete or create checkFetched, to automatically fetch the data at the specified index from the st... Alexandru Lungu

08:38 AM Bug #7174: Resolve simple CAN-FIND statements faster

Alexandru Lungu wrote:
> I think your <10% rates are error thresholds, considering that the first two optimizations ... Dănuț Filimon

07:23 AM Bug #7035 (Review): Extract query parameters from statically converted FQL

Committed 7035a/rev.14507. I applied the patch from #7035-11 which refactors @ParameterIndices@ into @ParameterDiff@ ... Dănuț Filimon

05:07 AM Bug #7035: Extract query parameters from statically converted FQL

I profiled #7035 fix again and I noticed a slight performance improvement this time. I think the optimization is havi... Alexandru Lungu

06:17 AM Bug #7167: Associating records from opened buffers to new sessions is slow

After a bit of investigation, the database sessions @com.goldencode.p2j.persist.orm.Session@ are closed quite eagerly... Alexandru Lungu

05:52 AM Bug #7165: Close multiplex scope using prepared statement

Alexandru Lungu wrote:
> * In @TemporaryBuffer.java@, add a proper default capacity for @additionalArgs@ and @ooArgs... Radu Apetrii

03/15/2023

01:18 PM Bug #6887: improve performance of dataset/table[-handle] parameters

I found a few points where we spend most CPU time:
# Reflexive invocation @java.lang.reflect.Method.invoke()@ - th... Boris Schegolev

12:45 PM Feature #6444: dataset improvements

Fixed the the NESTED/FOREIGN-KEY-HIDDEN support for WRITE-JSON.
6444a/14525.
The current status of the NESTED/FORE... Igor Skornyakov

11:13 AM Feature #6830 (Test): find and fix all SQL SELECT statements with inlined literal arguments, and ...

This reached trunk with 6129b. It can be closed.
#7165 was opened in the meantime targeting a "sub-issue" from here. Alexandru Lungu

11:10 AM Feature #6995 (Test): possibly support NO-UNDO temporary tables directly in H2

This reached trunk with 7026a. It can be closed. Alexandru Lungu

07:00 AM Bug #5306 (Review): AdaptiveQuery sets a found record into the buffer twice in dynamic mode

Committed fix for repetitive fetching in 7026b/rev. 14505. I also attached the changes here.
The fix is the same a... Alexandru Lungu

06:38 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns

I noticed a problem related to unique index/primary keys where the value that needs to be inserted is rtrimmed, but a... Dănuț Filimon

05:26 AM Feature #7061: Enable the use of lazy result sets in H2

Alexandru Lungu wrote:
> Radu, please commit #7061-28 patch to 7026b if there are no obvious problems in your tests.... Radu Apetrii

05:05 AM Feature #7061: Enable the use of lazy result sets in H2

Radu, please commit #7061-28 patch to 7026b if there are no obvious problems in your tests. I am looking forward to s... Alexandru Lungu

05:25 AM Bug #7174 (Review): Resolve simple CAN-FIND statements faster

> There is an improvement when using ANY instead of ONE for persistent tables when a findByUniqueIndex is detected. T... Alexandru Lungu

05:19 AM Bug #7165: Close multiplex scope using prepared statement

*Review of 7026b/rev. 14501*
* In @TemporaryBuffer.java@, add a proper default capacity for @additionalArgs@ and @... Alexandru Lungu

03/14/2023

02:11 PM Feature #6444: dataset improvements

Added FOREIGN-KEY-HIDDEN support for WRITE-XML,(READ|WRITE)-XMLSCHEMA.
Committed to 6444a/14524
The remaining thi... Igor Skornyakov

04:59 AM Feature #6444: dataset improvements

Rebased 6444a to the trunk/14503.
Pushed up to revision 14523.
Igor Skornyakov

04:51 AM Feature #6444: dataset improvements

Fixed @READ-XML(SCHEMA)?@ support for DATA-SETs with NESTED DATA-RELATIONs and multiple namespaces.
It works correct... Igor Skornyakov

12:30 PM Bug #7174: Resolve simple CAN-FIND statements faster

This semantic is why we have the @has{Any|One}@ nomenclature in @FindQuery@.
* @CAN-FIND({FIRST|LAST} ...)@ is con... Eric Faulhaber

09:35 AM Bug #7174: Resolve simple CAN-FIND statements faster

These are the expected results, where ONE is @CAN-FIND(tt)@, ANY is @CAN-FIND(FIRST tt)@.
|_. Number of records |_... Alexandru Lungu

09:23 AM Bug #7174: Resolve simple CAN-FIND statements faster

In OE, will a CAN-FIND ONE result return true if there is more than one match? In other words, is CAN-FIND ONE meant... Greg Shah

05:29 AM Bug #7174: Resolve simple CAN-FIND statements faster

I created tests that use simple queries, those tests consist of executing CAN-FIND for each record in a temporary/per... Dănuț Filimon

10:50 AM Bug #7138: Short circuit fake-update (update with a new value eqaul to the old value) in H2

Ovidiu Maxiniuc wrote:
> Alexandru Lungu wrote:
> > Right now, I am still dragged back by @String.hashCode@:
> > [... Alexandru Lungu

10:32 AM Bug #7138: Short circuit fake-update (update with a new value eqaul to the old value) in H2

Alexandru Lungu wrote:
> Right now, I am still dragged back by @String.hashCode@:
> [...]
Why is that? It seems li... Ovidiu Maxiniuc

09:42 AM Bug #7138: Short circuit fake-update (update with a new value eqaul to the old value) in H2

Ovidiu Maxiniuc wrote:
> Apparently, the hash short-circuit is not used. The @length@ of the strings are compared, b... Alexandru Lungu

08:46 AM Bug #7138: Short circuit fake-update (update with a new value eqaul to the old value) in H2

H2 database engine is built in Java. My first reaction to your hash suggestion was that it unneeded since Java has th... Ovidiu Maxiniuc

05:10 AM Bug #7138: Short circuit fake-update (update with a new value eqaul to the old value) in H2

... Alexandru Lungu

10:02 AM Feature #7194: Avoid generating an ORDER-BY clause if not required

This task targets the following scenario:... Alexandru Lungu

09:49 AM Feature #7194 (Closed): Avoid generating an ORDER-BY clause if not required

Alexandru Lungu

08:03 AM Feature #7062: Direct access to H2 internals to solve basic queries

Moved the @isFindByRowid@ short-circuit from #7062-30 to @RAQ.execute@. This is because @isSimpleQuery@ was always re... Alexandru Lungu

07:33 AM Bug #7185: H2 in-memory lazy hydration

Danut, please focus on implementing a demo for point 5 - we should have a fast mock to test its performance. Therefor... Alexandru Lungu

07:15 AM Bug #7185 (WIP): H2 in-memory lazy hydration

Alexandru Lungu

04:47 AM Bug #7165: Close multiplex scope using prepared statement

Alexandru Lungu wrote:
> Radu, please move 7061a, rev. 14487 to 7026b.
> I will review, test and profile it once th... Radu Apetrii

04:03 AM Bug #7165 (Review): Close multiplex scope using prepared statement

Radu, please move 7061a, rev. 14487 to 7026b.
I will review, test and profile it once there. Alexandru Lungu

03/13/2023

06:47 PM Bug #6887 (WIP): improve performance of dataset/table[-handle] parameters

I did more testing on provided code. The INPUT-OUTPUT DATASET-HANDLE is slightly slower in FWD, but it's definitely n... Boris Schegolev

03:44 PM Feature #6444: dataset improvements

Ovidiu Maxiniuc wrote:
> The main difference between @ds.xsd@ and the deserialied @hds.xsd@ is that the namespace, t... Igor Skornyakov

03:21 PM Feature #6444: dataset improvements

Igor Skornyakov wrote:
> I've noticed a strange thing. Consider the attached test @nested-test.p@.
> It defines a D... Ovidiu Maxiniuc

09:55 AM Feature #6444: dataset improvements

Radu Apetrii wrote:
> Igor Skornyakov wrote:
> > The problem is with 'lazyMode'. After applying the attached path t... Igor Skornyakov

09:32 AM Feature #6444: dataset improvements

Igor Skornyakov wrote:
> The problem is with 'lazyMode'. After applying the attached path the regression has gone.
... Radu Apetrii

05:28 AM Feature #6444: dataset improvements

Fixed minor issues with @WRITE-XML(SCHEMA)?@ for tables.
Committed to 6444a/14519. Igor Skornyakov

03:59 AM Feature #6444: dataset improvements

Eric Faulhaber wrote:
> Please post the test case, explain the regression to Radu, and let him fix it.
I'm workin... Radu Apetrii

03:09 AM Feature #6444: dataset improvements

Sorry, I've attached a wrong file. Igor Skornyakov

02:51 AM Feature #6444: dataset improvements

Eric Faulhaber wrote:
> Igor Skornyakov wrote:
> > Igor Skornyakov wrote:
> > > After rebasing I see a regression ... Igor Skornyakov

02:14 AM Feature #6444: dataset improvements

Igor Skornyakov wrote:
> Igor Skornyakov wrote:
> > After rebasing I see a regression in the FILL test for temporar... Eric Faulhaber

10:32 AM Bug #5306 (WIP): AdaptiveQuery sets a found record into the buffer twice in dynamic mode

Alexandru Lungu

07:37 AM Bug #7185: H2 in-memory lazy hydration

There is already some effort into lazy hydration as a general topic:
* supporting FIELDS/EXCEPT clause, so we can fe... Alexandru Lungu

03/12/2023

12:40 PM Feature #6444: dataset improvements

Igor Skornyakov wrote:
> After rebasing I see a regression in the FILL test for temporary source tables and recursiv... Igor Skornyakov

10:28 AM Feature #6444: dataset improvements

After rebasing I see a regression in the FILL test for temporary source tables and recursive DATA-RELATION. Igor Skornyakov

10:13 AM Feature #6444: dataset improvements

Rebased 6444a to the trunk/14500.
Pushed up to revision 14517. Igor Skornyakov

09:26 AM Feature #6444: dataset improvements

Fixed WRITE-XML(SCHEMA) for multiple namespaces and NESTED relations.
Committed to 6444a/14508. Igor Skornyakov

03/10/2023

02:09 PM Feature #6444: dataset improvements

Igor Skornyakov wrote:
> [...]
> This looks incorrect. As far as I understand which tables are missed depends on t... Eric Faulhaber

04:22 AM Feature #7061: Enable the use of lazy result sets in H2

Alexandru Lungu wrote:
> Radu, please review and test with your adaptive test cases (scrolling and non-scrolling).
... Radu Apetrii

03/09/2023

03:03 PM Bug #6919: fix ErrorManager.displayError in TempTableBuilder

My understanding is that we can close it. Boris Schegolev

01:20 PM Feature #6444: dataset improvements

More about the situation described in #6444-141.
Although in the Progress Developer Studio debugger @hds@ after im... Igor Skornyakov

08:39 AM Feature #6444: dataset improvements

I've noticed a strange thing. Consider the attached test @nested-test.p@.
It defines a DATA-SET with 5 tables (tt1... Igor Skornyakov

09:03 AM Bug #7185 (Test): H2 in-memory lazy hydration

Alexandru Lungu

07:54 AM Feature #7061: Enable the use of lazy result sets in H2

Constantin Asofiei wrote:
> Alexandru, is this patch meant to solve regressions? Because we are getting close to fin... Alexandru Lungu

07:48 AM Feature #7061: Enable the use of lazy result sets in H2

Alexandru, is this patch meant to solve regressions? Because we are getting close to finish testing 7026a, and unless... Constantin Asofiei

07:46 AM Feature #7061: Enable the use of lazy result sets in H2

After a self-review of the patch, I see that we still register the change broker for @AdaptiveQuery.open@ and there i... Alexandru Lungu

05:52 AM Feature #7061: Enable the use of lazy result sets in H2

Radu, this is the patch I am planning to integrate into 7026a to wrap-up the effort from #7061 and have a complete im... Alexandru Lungu

05:38 AM Feature #7061 (Review): Enable the use of lazy result sets in H2

Rebased 7061a to trunk (rev. 14497). Planning to merge your latest changes to 7026a as they target a temporary fix fr... Alexandru Lungu

05:00 AM Feature #7061: Enable the use of lazy result sets in H2

Alexandru Lungu wrote:
> Radu, is the multi-table @AdaptiveQuery@ considered for your implementation? I understood t... Radu Apetrii

07:39 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns

Alexandru Lungu wrote:
> * Note that you apply @s.replace(CASE_TYPE_TOK, "");@ to any type. You can do a check befor... Dănuț Filimon

03/08/2023

08:16 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns

Alexandru Lungu wrote:
> * testFWD shows regressions. I can't tell if they are false positives, but you should look ... Alexandru Lungu

07:43 AM Bug #7108 (Review): Simulate upper/rtrim directly in H2 using case specific columns

First thing to notice: the application always requires reconversion due to the new DDL for the H2 meta database (even... Alexandru Lungu

03/07/2023

09:43 AM Feature #7066 (WIP): Implement multi-table indexed query in H2

The purpose of this task too wide, especially after the implementation of the @lazy@ keyword. We should address some ... Alexandru Lungu

09:28 AM Feature #7062: Direct access to H2 internals to solve basic queries

The results were obtained using 7026a/rev. 14518. I don't have some results for 7026a/rev. 14503 for this specific ap... Alexandru Lungu

09:10 AM Feature #7062: Direct access to H2 internals to solve basic queries

Do these results differ from 7026a rev 14503? Greg Shah

08:44 AM Feature #7062: Direct access to H2 internals to solve basic queries

I've done the performance test on another large customer application. I've added more details to cover temp vs persis... Alexandru Lungu

08:59 AM Feature #7061: Enable the use of lazy result sets in H2

Radu, is the multi-table @AdaptiveQuery@ considered for your implementation? I understood that @lazy@ keyword works o... Alexandru Lungu

07:23 AM Feature #6444: dataset improvements

I've created a more advanced test with five tables, multiple namespaces and multiple nested data-reltions.
It appear... Igor Skornyakov

05:08 AM Bug #7174: Resolve simple CAN-FIND statements faster

Please note that we have a task regarding CAN-FIND (#7113) waiting for the code review.
Maybe it makes sense to wait... Igor Skornyakov

04:59 AM Bug #7174 (WIP): Resolve simple CAN-FIND statements faster

There are some opportunities to short-circuit the CAN-FIND query in FWD. A CAN-FIND statement is relaxed, in the sens... Alexandru Lungu

04:40 AM Bug #7174 (Closed): Resolve simple CAN-FIND statements faster

Alexandru Lungu

03:47 AM Bug #7165: Close multiplex scope using prepared statement

Alexandru Lungu wrote:
> @TemporaryBuffer.removeRecords@ is widely used when closing a multiplex scope, but not only... Radu Apetrii

03/06/2023

05:10 PM Bug #6812 (Review): fix FastFindCache to use a shared instance per persistent database

I prepared a change for the last missing bit (@SavepointManager@) - see revision 6812a/14487. It needs more testing, ... Boris Schegolev

06:52 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns

Alexandru Lungu wrote:
> We should integrate the first two for now to benefit from the "free meal". Danut, please co... Dănuț Filimon

03/03/2023

09:18 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns

Regarding @CompareModeDefault.compareString@, I found some neat means of short-circuiting. Note that neither @RuleBas... Alexandru Lungu

07:45 AM Bug #7167: Associating records from opened buffers to new sessions is slow

There are several moments when @Persistence$Context.getSession@ is used (usually by query execution, persistence reco... Alexandru Lungu

07:21 AM Bug #7167 (Closed): Associating records from opened buffers to new sessions is slow

Alexandru Lungu

05:40 AM Bug #7165: Close multiplex scope using prepared statement

We should also address the use of prepared statements when using @FastCopyHelper@. Most of the statements executed th... Alexandru Lungu

03/02/2023

02:11 PM Feature #6444: dataset improvements

I'm working now on the only remaining subtask - the @DATA-RELATION:FOREIGN-KEY-HIDDEN@ attribute support which can be... Igor Skornyakov

02:38 AM Feature #6444: dataset improvements

Rebased 6444a to the trunk/14486.
Pushed up to revision 14501. Igor Skornyakov

09:45 AM Feature #7061: Enable the use of lazy result sets in H2

Alexandru Lungu wrote:
> Radu, please confirm that your @lazy@ solution is eligible for the scrolling queries as wel... Radu Apetrii

05:13 AM Feature #7061: Enable the use of lazy result sets in H2

I've done some tests with another large customer application and I have the following statistics:
|_. Type |_. Tem... Alexandru Lungu

08:34 AM Bug #7165: Close multiplex scope using prepared statement

@TemporaryBuffer.removeRecords@ is widely used when closing a multiplex scope, but not only - e.g it is also used wit... Alexandru Lungu

08:22 AM Bug #7165 (Closed): Close multiplex scope using prepared statement

Alexandru Lungu

05:13 AM Feature #6995 (Review): possibly support NO-UNDO temporary tables directly in H2

Alexandru Lungu

05:12 AM Feature #6995 (WIP): possibly support NO-UNDO temporary tables directly in H2

_- deleted -_
Wrong post, it was meant to be for #7061. Alexandru Lungu

04:49 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2

Alexandru Lungu wrote:
> * Can't we have both @transactional@ and @no-undo@ create table statements? I see that "tra... Radu Apetrii

03/01/2023

01:31 PM Feature #6444: dataset improvements

Added support for the RESTART-ROW attribute.
Committed to 6444a/14499. Igor Skornyakov

05:19 AM Feature #7061: Enable the use of lazy result sets in H2

This is not the way to do it. @AdaptiveQuery.open@ is called only by explicit queries, usually dynamic (@QUERY-OPEN@ ... Alexandru Lungu

03:46 AM Feature #7061: Enable the use of lazy result sets in H2

Alexandru Lungu wrote:
> Further in my tests, I've got a crash when checking the dialect of the buffer in @AdaptiveQ... Radu Apetrii

02:12 AM Feature #6813: analyze and improve performance of dynamic conversion of temp-tables and queries

Thanks, I was thinking of something else and I recalled in the wrong way; in a customer app, buffer names are generat... Constantin Asofiei

02/28/2023

06:50 PM Feature #6813: analyze and improve performance of dynamic conversion of temp-tables and queries

Constantin, we are already doing this. After the query is parsed, the constants are extracted as variables. Each time... Ovidiu Maxiniuc

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

Pushed initial implementation of @DTTZ@ support in @SchemaCheck@ as revision 6371b/14486. I am just not sure where th... Boris Schegolev

07:23 AM Bug #7108: Simulate upper/rtrim directly in H2 using case specific columns

> One of the problems I have right now is that the rows are missing parameters when comparing in H2 and I am looking ... Dănuț Filimon

02:49 AM Feature #7062: Direct access to H2 internals to solve basic queries

Committed 7026a/14507 removing some tracing variables - missed them on my first check. Alexandru Lungu

02/27/2023

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

Tested and pushed Sequences and validations as revision 6371b/14485. Proceeding with timezone support. Boris Schegolev

09:24 AM Feature #7062: Direct access to H2 internals to solve basic queries

Done, committed 7026a/rev. 14506. Alexandru Lungu

08:04 AM Feature #7062: Direct access to H2 internals to solve basic queries

Alexandru Lungu wrote:
> [...]
> I will also allow such optimization for queries without client-where, joins and ex... Constantin Asofiei

08:01 AM Feature #7062: Direct access to H2 internals to solve basic queries

... Alexandru Lungu

07:58 AM Feature #7062: Direct access to H2 internals to solve basic queries

This was a last minute modification and the @LOCK_MODE 0@ from H2 was stuck in my head. It struck me at some point th... Alexandru Lungu

07:47 AM Feature #7062: Direct access to H2 internals to solve basic queries

Alexandru, the changes in RandomAccessQuery will not set the lock properly on a record found in the cache:... Constantin Asofiei

08:53 AM Feature #6995: possibly support NO-UNDO temporary tables directly in H2

Integrated the patch into 7062a. Also, the H2 changes made it to trunk.
I've reviewed the changes again and I have... Alexandru Lungu

08:45 AM Bug #7132: Eliminate for-each loops and lambda in FWD-H2 code

Done several testing iterations with 7132a_h2/rev. 15 and the issue is solved. The bad news are that I couldn't notic... Alexandru Lungu

04:58 AM Feature #6444: dataset improvements

Tested the (de)serialization of recursive data relation for the remote calls.
Works OK. Igor Skornyakov

03:56 AM Feature #6582: implement multi-table AdaptiveQuery

#7061 is mostly finished and now we have a @lazy@ keyword in FWD-H2 which works as a H2 database-cursor allowing us t... Alexandru Lungu

03:15 AM Feature #7061: Enable the use of lazy result sets in H2

Radu, I merged your changes from 7061a to 7026a. Note that 7026a is frozen right now.
First of all, I moved @suppo... Alexandru Lungu