Activity

From 04/21/2020 to 05/20/2020

05/20/2020

07:00 AM Feature #3814: more schema metadata: Greg Shah wrote:
> I think 4231b is fine.
Committed to 4231b revision 11549. ... Igor Skornyakov
06:35 AM Feature #3814: more schema metadata: I think 4231b is fine. Greg Shah

05/19/2020

04:19 PM Feature #3814: more schema metadata: Igor Skornyakov wrote:
> I've finished the population of the @_File@, @_Field@, @_Index@, and @_Index-Field@ system ... Igor Skornyakov
02:58 PM Feature #4011: database/persistence layer performance improvements: I've just committed my latest changes to 4011 as r11437.
The most important thing here is the fix for the endless qu... Ovidiu Maxiniuc
10:00 AM Feature #4011: database/persistence layer performance improvements: Greg Shah wrote:
> > but in 4011 this is automatically done by DmoMetadataManager. The 4011 uses the new syntax supp... Ovidiu Maxiniuc

05/18/2020

06:53 PM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> OTOH, the @ProgressiveResults@ have @sessionClosing()@ method which will duplicate the un... Eric Faulhaber
06:27 PM Feature #4011: database/persistence layer performance improvements: Greg Shah wrote:
> > but in 4011 this is automatically done by DmoMetadataManager. The 4011 uses the new syntax supp... Eric Faulhaber
06:04 PM Feature #4011: database/persistence layer performance improvements: > but in 4011 this is automatically done by DmoMetadataManager. The 4011 uses the new syntax supported by H2 (and PSQ... Greg Shah
05:49 PM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> [..] when a query is associated with a browse, apparently we need some special treatment, be... Ovidiu Maxiniuc
04:00 PM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> Separately, I committed rev 11436, which completes the fix to the server startup performance... Ovidiu Maxiniuc
05:02 AM Feature #4011: database/persistence layer performance improvements: The @UniqueTracker@ empty scopes issue seems to be caused by the fact that we aren't registering the tracker for @Fin... Eric Faulhaber
05:44 PM Feature #3814: more schema metadata: I've finished the population of the @_File@, @_Field@, @_Index@, and @_Index-Field@ system tables base on DMO reflect... Igor Skornyakov

05/16/2020

01:53 AM Feature #4011: database/persistence layer performance improvements: Running a single ETF test results in some errors...... Eric Faulhaber

05/15/2020

07:12 PM Feature #4011: database/persistence layer performance improvements: The long delay during ETF server startup while processing index metadata appears to be due to the fact that we swappe... Eric Faulhaber
06:57 PM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> Eric Faulhaber wrote:
> > * Using the mouse wheel to scroll down in the "Available Rooms" ... Eric Faulhaber
06:32 PM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> * Using the mouse wheel to scroll down in the "Available Rooms" tab browse results in an end... Ovidiu Maxiniuc
05:07 PM Feature #3814: more schema metadata: The @_File@ table population for a large customer application (both system and user tables) takes ~100 ms in my envir... Igor Skornyakov
12:55 PM Feature #3814: more schema metadata: Ovidiu Maxiniuc wrote:
> Igor Skornyakov wrote:
> > I'm a little bit confused with the discussion in #3145. At the ... Igor Skornyakov
12:07 PM Feature #3814: more schema metadata: Igor Skornyakov wrote:
> I'm a little bit confused with the discussion in #3145. At the bottom line - is it OK to se... Ovidiu Maxiniuc
06:18 AM Feature #3814: more schema metadata: I'm a little bit confused with the discussion in #3145. At the bottom line - is it OK to set the value of the @_Templ... Igor Skornyakov
02:55 AM Feature #3814: more schema metadata: Eric Faulhaber wrote:
> Igor Skornyakov wrote:
>
> > [...]
> > I've noticed that the current data for the @_User... Igor Skornyakov
10:04 PM Feature #3814: more schema metadata: Igor Skornyakov wrote:
> [...]
> I've noticed that the current data for the @_User@ table in the @xxx.meta.xml@ f... Eric Faulhaber

05/14/2020

05:45 PM Feature #3814: more schema metadata: Ovidiu Maxiniuc wrote:
> Igor Skornyakov wrote:
> > [...] and @_Template@ is always zero (not a negative number).
... Igor Skornyakov
05:15 PM Feature #3814: more schema metadata: Igor Skornyakov wrote:
> [...] and @_Template@ is always zero (not a negative number).
I do not remember exactly, b... Ovidiu Maxiniuc
05:04 PM Feature #3814: more schema metadata: Populating @_File@ system table based *only* on database metadata (provided by @Connection.getMetaData()@) looks to b... Igor Skornyakov
03:55 PM Feature #4011: database/persistence layer performance improvements: Hotel GUI r220 issues with 4011a:
* Adding a guest to the "Check-In" dialog replaces the existing guest instead of... Eric Faulhaber
03:26 PM Feature #4011: database/persistence layer performance improvements: I noticed something else related to assigns, which will probably not be handled in this task: the way the ASSIGN trig... Ovidiu Maxiniuc
03:12 PM Feature #4011: database/persistence layer performance improvements: Greg Shah wrote:
> We've never seen this behavior before. I think it can only be seen in a @NO-ERROR@ case because ... Ovidiu Maxiniuc
07:24 AM Feature #4011: database/persistence layer performance improvements: > Next, if we enable the two commented lines the program will print 0 ? because the values of k and f11 will be rolle... Greg Shah
09:44 PM Feature #4011: database/persistence layer performance improvements: Indeed, to observe the null-mandatory-nonValidated field case the field initial value must be declared @?@, like:
<p... Ovidiu Maxiniuc

05/13/2020

07:08 PM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> Related to not-null/mandatory validation. There are some issues with current implementation... Eric Faulhaber
04:28 PM Feature #4011: database/persistence layer performance improvements: Related to not-null/mandatory validation. There are some issues with current implementation.
* 1st: there is a two... Ovidiu Maxiniuc
03:12 PM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> I will do a test on my HDD to give as a base for comparing future work. How many threads ... Eric Faulhaber
06:19 AM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> Revision 11434 implements bulk insert (i.e., broader SQL batching) and a few other optimizat... Ovidiu Maxiniuc
04:05 AM Feature #4011: database/persistence layer performance improvements: Revision 11434 implements bulk insert (i.e., broader SQL batching) and a few other optimizations for the database imp... Eric Faulhaber
09:33 AM Bug #3471: incremental conversion is regressed: Some other parts which are required for incremental conversion:
* the @.wsdl@ generation for exported SOAP services... Constantin Asofiei

05/12/2020

08:07 AM Feature #3814: more schema metadata: Greg Shah wrote:
> > This can result in a performance drag on the system, in that the maintenance of the state of th... Igor Skornyakov
08:03 AM Feature #3814: more schema metadata: > do we already have an issue for this?
Not that I recall.
> I do not want to include all system tables support... Greg Shah

05/11/2020

07:28 PM Feature #3814: more schema metadata: Igor Skornyakov wrote:
> I do not see any potential conflicts between what I see in 4011a and my changes in 4231b. S... Eric Faulhaber
06:37 PM Feature #3814: more schema metadata: I've made @MetadataManager.initialize()@ implementation as close to one in 4011a as possible. Both implementations a... Igor Skornyakov
06:52 AM Feature #3814: more schema metadata: I do not see any potential conflicts between what I see in 4011a and my changes in 4231b. Some changes will be requir... Igor Skornyakov
02:01 PM Feature #4011: database/persistence layer performance improvements: Thanks for the batch size fix, I hadn't noticed that. Yes, the import organizes the records into batches, but we don'... Eric Faulhaber
12:13 PM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> I've been running database import and I noticed something surprising in the import worker co... Ovidiu Maxiniuc
05:42 AM Feature #4011: database/persistence layer performance improvements: I'm trying to run my standalone test with H2 database. It runs fine with 4231b, but with 4011a the server fails at st... Igor Skornyakov
04:32 AM Feature #4011: database/persistence layer performance improvements: I've been running database import and I noticed something surprising in the import worker code:... Eric Faulhaber

05/10/2020

03:31 AM Feature #4011: database/persistence layer performance improvements: To clarify, that last line refers to deleting DMOs one at a time using @Persistence.delete@, as is done in the persis... Eric Faulhaber
03:27 AM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> Eric Faulhaber wrote:
> > Ovidiu Maxiniuc wrote:
> > > [...]
> > > I think this region o... Eric Faulhaber

05/09/2020

09:41 AM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> Ovidiu Maxiniuc wrote:
> > [...]
> > I think this region of the persistence was not altere... Ovidiu Maxiniuc
06:38 AM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> [...]
> I think this region of the persistence was not altered. I wonder how this was work... Eric Faulhaber

05/08/2020

07:55 PM Feature #4011: database/persistence layer performance improvements: Please find the TempTable DataSource management patch as r11432. I tested the web client and multiple clients connect... Ovidiu Maxiniuc
07:09 PM Feature #4011: database/persistence layer performance improvements: I was testing the new datasource/connection when I encounter the following issue: once a dynamic table (probably not ... Ovidiu Maxiniuc
06:08 PM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> Ovidiu, w.r.t. the ETF import taking almost 17 hours, is that normal for that machine? It se... Eric Faulhaber
05:59 PM Feature #4011: database/persistence layer performance improvements: Agreed. That's what I was trying to suggest, but you summarized it better.
Also, looking back at how it ended up, ... Eric Faulhaber
05:54 PM Feature #4011: database/persistence layer performance improvements: I think the framework might work with this idea: we just move the context from the @TempTableDataSourceProvider@, to ... Ovidiu Maxiniuc
05:46 PM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> The problem is in @JdbcDataSource@. For temp-tables, it is built from the @DataSourceImpl@ ... Eric Faulhaber
05:04 PM Feature #4011: database/persistence layer performance improvements: The problem is in @JdbcDataSource@. For temp-tables, it is built from the @DataSourceImpl@ returned by the @TempTable... Ovidiu Maxiniuc
04:25 PM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> Ovidiu Maxiniuc wrote:
>
> > I investigated the connections and they seem to share the sa... Eric Faulhaber
12:37 PM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> I investigated the connections and they seem to share the same connection. I will investi... Eric Faulhaber
06:18 AM Feature #4011: database/persistence layer performance improvements: I tried connecting with two clients at once: the Swing client first (only connect, no other clicks) and then the embe... Ovidiu Maxiniuc
04:32 AM Feature #4011: database/persistence layer performance improvements: Ovidiu, w.r.t. the ETF import taking almost 17 hours, is that normal for that machine? It seems really long to me. Wi... Eric Faulhaber
04:08 AM Feature #4011: database/persistence layer performance improvements: Thanks for the fixes.
I rebuilt and converted Hotel GUI from scratch. The import worked, but unfortunately, I stil... Eric Faulhaber
09:59 PM Feature #4011: database/persistence layer performance improvements: New update, r11431.
There was an issue with _temp records fetched by loader. The hydration wasn't setting up the @_m... Ovidiu Maxiniuc
03:20 AM Feature #3757: add metadata support: Ovidiu Maxiniuc wrote:
> Igor,
> I do not remember exactly why the @ _database-feature@ was removed. It seems to me... Igor Skornyakov

05/07/2020

07:24 PM Feature #4011: database/persistence layer performance improvements: Eric,
Please grab -r11429- LE:r11430. I have a separate directory for commits and I forgot to compare and merge in t... Ovidiu Maxiniuc
06:38 PM Feature #4011: database/persistence layer performance improvements: Ovidiu, I'm getting this during the import step:... Eric Faulhaber
04:40 PM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> The standalone clients now can sequentially connect to server and the table/index cleanup... Eric Faulhaber
04:15 PM Feature #4011: database/persistence layer performance improvements: I have just committed r11429. Changes include:
* moved DDL generation from @DmoMetadataManager@ to @TempTableHelper@... Ovidiu Maxiniuc
04:27 AM Feature #4011: database/persistence layer performance improvements: I committed rev 11427, which adds the placeholder suffix at the end of temp-table index names. Note that this short t... Eric Faulhaber
04:19 AM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> This must be done as some things changed: @id@/@recid@ as PK, @identifier@/@id@, datetime... Eric Faulhaber
10:43 PM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> Please prioritize the temp-table name suffix fix. I'd like to see this go in as soon as poss... Eric Faulhaber
08:38 PM Feature #4011: database/persistence layer performance improvements: Please prioritize the temp-table name suffix fix. I'd like to see this go in as soon as possible, even if nothing els... Eric Faulhaber
07:17 PM Feature #3757: add metadata support: Igor,
I do not remember exactly why the @ _database-feature@ was removed. It seems to me that, since work on @_ActLo... Ovidiu Maxiniuc
06:24 PM Feature #3757: add metadata support: Greg Shah wrote:
> I had not planned for you to make everything "live" yet. For this current task, it is OK to exte... Igor Skornyakov
06:16 PM Feature #3757: add metadata support: I had not planned for you to make everything "live" yet. For this current task, it is OK to extend the current stati... Greg Shah
04:59 PM Feature #3757: add metadata support: Ovidiu Maxiniuc wrote:
> The @_database-feature@ has the runtime support in @MetadataManager.populateDatabaseFeature... Igor Skornyakov

05/06/2020

07:52 PM Feature #4011: database/persistence layer performance improvements: The following is a short discussion from email, with my last replies:
Eric Faulhaber wrote:
> On 5/6/20 4:33 PM, Ov... Ovidiu Maxiniuc
05:56 PM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> ... the @TempTableHelper@ also keeps a static @cache@ in a form of a @HashMap@ which is nev... Eric Faulhaber
03:51 PM Feature #4011: database/persistence layer performance improvements: It doesn't matter much to me where we keep the cache... wherever you think it makes the most sense is fine.
As to... Eric Faulhaber
01:59 PM Feature #4011: database/persistence layer performance improvements: Eric,
Your statements are correct. I added the code exactly as you described them an continued some investigations. ... Ovidiu Maxiniuc
08:25 AM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> Constantin, I am hitting a resource cleanup problem with a persistent procedure in Hotel GUI... Constantin Asofiei
07:33 AM Feature #4011: database/persistence layer performance improvements: Ovidiu, I've committed rev 11427, which partially fixes persistence context cleanup. However, I found a problem with ... Eric Faulhaber
04:22 AM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> Constantin, I am hitting a resource cleanup problem with a persistent procedure in Hotel GUI... Constantin Asofiei
04:12 AM Feature #4011: database/persistence layer performance improvements: Constantin, I am hitting a resource cleanup problem with a persistent procedure in Hotel GUI. The procedure is the co... Eric Faulhaber
01:09 PM Feature #3814: more schema metadata: It's #4155.
I was looking for #3757 several days ago and for some reasons I could not reach it. Thanks for finding i... Ovidiu Maxiniuc
01:00 PM Feature #3814: more schema metadata: Ovidiu Maxiniuc wrote:
> I will answer this:
> there are a few versions of @standard.df@ in use. Depending on the v... Roger Borrello
12:46 PM Feature #3814: more schema metadata: Roger Borrello wrote:
> Igor,
> On a project, we had to include @_connect@ in the @metadata@. At that point, we rec... Ovidiu Maxiniuc
12:38 PM Feature #3814: more schema metadata: Igor,
On a project, we had to include @_connect@ in the @metadata@. At that point, we received @java.lang.ClassNot... Roger Borrello

05/05/2020

08:12 AM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> Constantin, can you please point me at some test cases which use buffers in persistent proce... Constantin Asofiei
05:45 AM Feature #4011: database/persistence layer performance improvements: I committed rev 11426, which attempts to fix the session closing issue. However, there is still a problem, which I am... Eric Faulhaber
05:42 AM Feature #4011: database/persistence layer performance improvements: Tried an ETF run. Server startup reported these errors:... Eric Faulhaber
03:44 AM Bug #3471: incremental conversion is regressed: Eric, I've noticed something while looking at #4633. The @SchemaWorker.joins@ does not survive for incremental conve... Constantin Asofiei

05/01/2020

04:11 PM Feature #4011: database/persistence layer performance improvements: Constantin, can you please point me at some test cases which use buffers in persistent procedures? Eric Faulhaber
01:40 PM Feature #4011: database/persistence layer performance improvements: Committed 11423. Changes:
* fixed regression in _meta tables;
* skip re-hydration of records if a non STALE copy is... Ovidiu Maxiniuc
07:31 AM Feature #4011: database/persistence layer performance improvements: I do not know the exact H2 implementation, but it seems to me logical that once the table is LOCAL, its indexes will ... Ovidiu Maxiniuc
06:44 AM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> At this moment we have some @Session@ -related events: SESSION_CLEANUP, SESSION_CLOSING_N... Eric Faulhaber
06:11 AM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> We have not changed the approach to "static" metadata tables in this branch, and we're makin... Igor Skornyakov
06:06 AM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> We have not changed the approach to "static" metadata tables in this branch, and we're makin... Ovidiu Maxiniuc
06:03 AM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> Ovidiu, AFAICT, we do not do any explicit closing of resources associated with converted, le... Ovidiu Maxiniuc
06:01 AM Feature #4011: database/persistence layer performance improvements: We have not changed the approach to "static" metadata tables in this branch, and we're making only minimal changes to... Eric Faulhaber
05:52 AM Feature #4011: database/persistence layer performance improvements: Gentlemen,
I'm working on metatables support right now. Maybe it makes sense for me to use your branch?
Thank you. Igor Skornyakov
05:48 AM Feature #4011: database/persistence layer performance improvements: No worries. The patch I used to get past it is attached. If you're ok with it (I didn't test the case where the @Meta... Eric Faulhaber
05:43 AM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> The discussion of modifying the approach on the metadata DMOs notwithstanding, the current a... Ovidiu Maxiniuc
04:30 AM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> Last night I committed r11422.
> This revision re-enables @LockTableUpdater@, @ConnectTab... Eric Faulhaber

04/30/2020

06:56 PM Feature #4011: database/persistence layer performance improvements: Constantin Asofiei wrote:
> For persistent procedures, a buffer will live as long as that program lives.
Hm, ri... Eric Faulhaber
06:24 PM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> Specifically, I provisionally have decided on the approach where we tie the database session... Constantin Asofiei
05:55 PM Feature #4011: database/persistence layer performance improvements: Constantin, I need some guidance on my previous entry.
Specifically, I provisionally have decided on the approach ... Eric Faulhaber
03:50 PM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> If @Persistence.closeSession(false)@ is called only from @Persistence$Context.cleanup()@. T... Eric Faulhaber
10:08 AM Feature #4011: database/persistence layer performance improvements: I agree that refactoring and using modules are both very good things. And we are definitely wanting to do some of th... Greg Shah
09:34 AM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> When we upgrade to Java9 we could make use of the new modules and compile them independentl... Igor Skornyakov
09:24 AM Feature #4011: database/persistence layer performance improvements: Greg Shah wrote:
> In #4155 we are working to eliminate use of the @.df@. And converting as part of the build proce... Ovidiu Maxiniuc
09:10 AM Feature #4011: database/persistence layer performance improvements: Greg Shah wrote:
> In #4155 we are working to eliminate use of the @.df@. And converting as part of the build proce... Igor Skornyakov
08:58 AM Feature #4011: database/persistence layer performance improvements: In #4155 we are working to eliminate use of the @.df@. And converting as part of the build process leads to a bootst... Greg Shah
08:50 AM Feature #4011: database/persistence layer performance improvements: Greg Shah wrote:
> > taking in consideration that we do not have the class at the moment FWD is compiled
>
> In m... Ovidiu Maxiniuc
08:44 AM Feature #4011: database/persistence layer performance improvements: > taking in consideration that we do not have the class at the moment FWD is compiled
In my opinion, it makes no s... Greg Shah

04/29/2020

05:29 PM Feature #4011: database/persistence layer performance improvements: Last night I committed r11422.
This revision re-enables @LockTableUpdater@, @ConnectTableUpdater@ and @TransactionT... Ovidiu Maxiniuc
04:09 PM Feature #4011: database/persistence layer performance improvements: If @Persistence.closeSession(false)@ is called only from @Persistence$Context.cleanup()@. This is the end of session,... Ovidiu Maxiniuc
02:33 PM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> Just committed r11421.
> There are two changes:
> # in @Persistence.closeSession(boolean)... Eric Faulhaber
06:32 AM Feature #4011: database/persistence layer performance improvements: For now, don't change what the queries fetch. If a query fetches all columns, leave it that way, but ensure the prima... Eric Faulhaber
08:47 PM Feature #4011: database/persistence layer performance improvements: I observed the following usecase:
* some records are created fresh in a loop and get saved. They are successfully in... Ovidiu Maxiniuc

04/28/2020

04:20 PM Feature #4011: database/persistence layer performance improvements: Just committed r11421.
There are two changes:
# in @Persistence.closeSession(boolean)@, the @closeSessionImpl(error... Ovidiu Maxiniuc
01:36 PM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> Briefly speaking, the problem is caused because the static temp-tables are 'permanent', a... Eric Faulhaber
11:50 AM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> One more issue to fix is that it seems we are not properly dropping indexes on temporary tab... Ovidiu Maxiniuc
08:18 AM Feature #4011: database/persistence layer performance improvements: > At each nested block within that application transaction, the SavepointManager sets a database savepoint. If that b... Greg Shah
05:51 AM Feature #4011: database/persistence layer performance improvements: One more issue to fix is that it seems we are not properly dropping indexes on temporary tables upon exiting Hotel GU... Eric Faulhaber
05:32 AM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> For undoable DMOs marked stale, the next access forces a re-read of that DMO's data from t... Eric Faulhaber
05:25 AM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> I think there is an issue with the nesting transactions. [...]
I debugged through this... Eric Faulhaber
04:20 AM Feature #4011: database/persistence layer performance improvements: Thanks for clarifications, I will use these information (from both your last posts) to continue investigations on the... Ovidiu Maxiniuc
03:37 AM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> Eric Faulhaber wrote:
> > I don't intentionally create nested transactions, in fact, the @... Eric Faulhaber
03:09 AM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> Eric Faulhaber wrote:
> > Can you please share the reasoning behind your change?
> The ... Eric Faulhaber
09:10 PM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> I don't intentionally create nested transactions, in fact, the @inTx@ flag in @Session@ is i... Ovidiu Maxiniuc
09:03 PM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> Can you please share the reasoning behind your change?
The usecase is when same dmo is load... Ovidiu Maxiniuc
08:50 PM Feature #4011: database/persistence layer performance improvements: Ovidiu, the change in 11418 to @Session.save@ seems dangerous to me. The reason for the check to test whether another... Eric Faulhaber
12:16 PM Feature #4397: add database attrs, methods and options: Greg Shah wrote:
> The runtime would be up to Eric/Ovidiu. After #4011, they have plenty of control all the way dow... Ovidiu Maxiniuc
10:08 AM Feature #4397: add database attrs, methods and options: 4231b rev 11493 :
* added BUFFER:LAST-BUFFER and QUERY's callback API support
* fixed EXCEPT/FIELDS option with a r... Constantin Asofiei
09:43 AM Feature #4397: add database attrs, methods and options: Looks like FIELDS and EXCEPT are already supported for this case:... Constantin Asofiei
09:41 AM Feature #4397: add database attrs, methods and options: The runtime would be up to Eric/Ovidiu. After #4011, they have plenty of control all the way down to the JDBC driver. Greg Shah
09:24 AM Feature #4397: add database attrs, methods and options: I understand the reasoning behind it, to limit the amount of data retrieved by a query; but, my point is that to make... Constantin Asofiei
09:15 AM Feature #4397: add database attrs, methods and options: Constantin Asofiei wrote:
> I recall way back that we had a talk about FIELDS/EXCEPT with a record phrase, and with ... Greg Shah
08:16 AM Feature #4397: add database attrs, methods and options: Yes, it exists:... Constantin Asofiei
08:12 AM Feature #4397: add database attrs, methods and options: Constantin Asofiei wrote:
> > Where did you find from of the existence of the attribute for dataset objects? Custome... Ovidiu Maxiniuc
07:32 AM Feature #4397: add database attrs, methods and options: Ovidiu Maxiniuc wrote:
> Constantin Asofiei wrote:
> > Just a note, there is a @DATASET:FILL-MODE@ attribute which ... Constantin Asofiei
07:01 AM Feature #4397: add database attrs, methods and options: Constantin Asofiei wrote:
> Just a note, there is a @DATASET:FILL-MODE@ attribute which I stubbed in 4231b. FWD now... Ovidiu Maxiniuc
10:16 AM Feature #3814: more schema metadata: Greg Shah wrote:
> > Why not keep the metadata in the database as 4GL does?
>
> Just because the 4GL represents t... Igor Skornyakov
10:08 AM Feature #3814: more schema metadata: > Why not keep the metadata in the database as 4GL does?
Just because the 4GL represents these as tables, doesn't ... Greg Shah
09:49 AM Feature #3814: more schema metadata: Greg Shah wrote:
> When you add a column or an index post-conversion, it must be represented in the metadata. Relyi... Igor Skornyakov
08:00 AM Feature #3814: more schema metadata: When you add a column or an index post-conversion, it must be represented in the metadata. Relying upon static defin... Greg Shah

04/27/2020

07:20 PM Feature #3814: more schema metadata: Greg Shah wrote:
> At least for tables such as @file_@ or @field_@, these must always represent the latest structu... Eric Faulhaber
06:47 PM Feature #3814: more schema metadata: Greg Shah wrote:
> > I can easily imagine the situation when we'll be able to provide compatibility with 4GL for the... Igor Skornyakov
06:35 PM Feature #3814: more schema metadata: > I can easily imagine the situation when we'll be able to provide compatibility with 4GL for the application if we w... Greg Shah
06:00 PM Feature #3814: more schema metadata: Greg Shah wrote:
> > I've not realized this. In any case, the content of the non-VST system tables should be really ... Igor Skornyakov
05:45 PM Feature #3814: more schema metadata: > I've not realized this. In any case, the content of the non-VST system tables should be really persistent and survi... Greg Shah
05:25 PM Feature #3814: more schema metadata: Constantin Asofiei wrote:
> Igor, AFAIK the meta database in FWD is a separate H2 in-memory database, for each physi... Igor Skornyakov
05:20 PM Feature #3814: more schema metadata: Igor, AFAIK the meta database in FWD is a separate H2 in-memory database, for each physical database. So even if the... Constantin Asofiei
04:31 PM Feature #3814: more schema metadata: Eric Faulhaber wrote:
> Igor Skornyakov wrote:
> > Well, it seems that we need some changes in the conversion proce... Igor Skornyakov
04:20 PM Feature #3814: more schema metadata: Igor Skornyakov wrote:
> Well, it seems that we need some changes in the conversion process. The SCHEMA meta tables ... Eric Faulhaber
06:44 PM Feature #4397: add database attrs, methods and options: I recall way back that we had a talk about FIELDS/EXCEPT with a record phrase, and with our current FWD, it doesn't m... Constantin Asofiei
06:39 PM Feature #4397: add database attrs, methods and options: Just a note, there is a @DATASET:FILL-MODE@ attribute which I stubbed in 4231b. FWD now has runtime only for @BUFFER... Constantin Asofiei
05:37 PM Feature #4011: database/persistence layer performance improvements: I don't intentionally create nested transactions, in fact, the @inTx@ flag in @Session@ is intended specifically to a... Eric Faulhaber
05:24 PM Feature #4011: database/persistence layer performance improvements: Eric,
I committed a small update that will make the embedded client work. See r11418.
But I have the following is... Ovidiu Maxiniuc
03:45 PM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> [...]
> This was making sense when we let Hibernate do the flush as late as possible, bu... Eric Faulhaber
08:47 AM Feature #4011: database/persistence layer performance improvements: Eric,
We need to discuss the ... Ovidiu Maxiniuc
06:05 AM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> This is fixed in rev 11417.
Super!
> Ovidiu, after the issues in #4011-241, could you al... Ovidiu Maxiniuc
06:00 AM Feature #4011: database/persistence layer performance improvements: Ovidiu, after the issues in #4011-241, could you also please take a look at what is going wrong with embedded mode Ho... Eric Faulhaber
05:48 AM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> Eric Faulhaber wrote:
> > What is the recreate for this? I can have a look.
> Available R... Eric Faulhaber
02:15 AM Feature #4011: database/persistence layer performance improvements: Ovidiu, thanks for the fixes in rev 11416. Please look at these next, which occur when you try to manipulate the tree... Eric Faulhaber

04/25/2020

02:48 PM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> I've now come across a dynamic database problem in Hotel GUI (virtual desktop). On the "Room... Ovidiu Maxiniuc
02:37 PM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> What is the recreate for this? I can have a look.
Available Rooms > Check-In > (select a gu... Ovidiu Maxiniuc
02:34 PM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> The issue I was after yesterday changes a bit. [...]
What is the recreate for this? I ... Eric Faulhaber
11:28 AM Feature #4011: database/persistence layer performance improvements: Eric,
The issue I was after yesterday changes a bit. Now I am getting the following NPE when a record is deleted:
<... Ovidiu Maxiniuc
09:01 AM Feature #4011: database/persistence layer performance improvements: > The problem with my last revision is that I was assuming Finalizable entry and finished calls were always paired, w... Greg Shah
04:19 AM Feature #4011: database/persistence layer performance improvements: I've committed rev 11415, which I believe fixes the @UniqueTracker@ scope imbalance problem. I think the logic is sou... Eric Faulhaber

04/24/2020

04:11 PM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> the first part, @on commit drop@ means to drop the table on transaction commit. Now, I do... Eric Faulhaber
10:07 AM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> Why do we create temp tables with the postfix @on commit drop transactional@? What does this... Ovidiu Maxiniuc
04:23 AM Feature #4011: database/persistence layer performance improvements: Update on the unbalanced scopes in @UniqueTracker@...
I've reworked the scope mechanism in @UniqueTracker@ to rely... Eric Faulhaber
02:19 PM Feature #4375: add support for -pf <profile_filename> option for CONNECT statement: Greg Shah wrote:
> It looks like rev 11369 of 4231b.
>
> As you develop changes for a task, please keep the @% Do... Igor Skornyakov
01:29 PM Feature #4375 (Test): add support for -pf <profile_filename> option for CONNECT statement: It looks like rev 11369 of 4231b.
As you develop changes for a task, please keep the @% Done@ and @Status@ updated... Greg Shah
01:13 PM Feature #4375: add support for -pf <profile_filename> option for CONNECT statement: Greg Shah wrote:
> Are the changes in 4231b?
I do not remember. I think that they are in the trunk already. Igor Skornyakov
01:12 PM Feature #4375: add support for -pf <profile_filename> option for CONNECT statement: Are the changes in 4231b? Greg Shah
01:11 PM Feature #4375: add support for -pf <profile_filename> option for CONNECT statement: This was done in the scope of #3813. Igor Skornyakov
11:46 AM Feature #4375: add support for -pf <profile_filename> option for CONNECT statement: I think I mistakenly assigned you #4392 previously, but meant for you to work this one. Greg Shah
01:06 PM Feature #4175: add support for -1 (single user) option for CONNECT statement: I was not working in this task/ As far as I remember, I was reassigned to another one. Igor Skornyakov
11:44 AM Feature #4175: add support for -1 (single user) option for CONNECT statement: What is the status of this task? Greg Shah

04/23/2020

04:58 PM Feature #4011: database/persistence layer performance improvements: Why do we create temp tables with the postfix @on commit drop transactional@? What does this do? Eric Faulhaber
03:49 PM Feature #4011: database/persistence layer performance improvements: I just committed r11414. Here are the changes:
* changed the initialization of @_metadata@ of @DmoClass@ generated c... Ovidiu Maxiniuc
02:33 PM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> Do we need to be so eager to close the session in the attempt to salvage the normal execu... Eric Faulhaber
10:44 AM Feature #4011: database/persistence layer performance improvements: I used r11413 and the hotel_gui has @deploy.all@-ed smoothly. I found some new hardcoded @id@ which were replaced wit... Ovidiu Maxiniuc
08:15 AM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> I was not thinking of database import when I put @PRIMARY_KEY_NAME@ into @DatabaseManager@. ... Ovidiu Maxiniuc
06:10 AM Feature #4011: database/persistence layer performance improvements: The attached changes to @directory.xml@ are needed to adjust for the removal of Hibernate. Note that these are just t... Eric Faulhaber
06:02 AM Feature #4011: database/persistence layer performance improvements: I checked in rev 11413, which fixes a few bugs (hard-coded references to @id@ as primary key) and makes @Session.PK@ ... Eric Faulhaber
04:44 AM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> * the @DatabaseManager.PRIMARY_KEY@ is used when initializing the @DmoMeta@ for each DMO ... Eric Faulhaber
09:33 AM Bug #3471: incremental conversion is regressed: 4231b rev -11481- 11482 contains more performance fixes (again, related to the @tmpTabNodes@ and @AstKey@):
* collec... Constantin Asofiei

04/22/2020

03:31 PM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
> Is @MultiClassLoader@ really needed for the import, or just @AsmClassLoader@?
Good point.... Ovidiu Maxiniuc
03:24 PM Feature #4011: database/persistence layer performance improvements: Is @MultiClassLoader@ really needed for the import, or just @AsmClassLoader@? Eric Faulhaber
03:21 PM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> BTW, for import and server to start the
> @-Djava.system.class.loader=com.goldencode.p2... Eric Faulhaber
03:20 PM Feature #4011: database/persistence layer performance improvements: BTW, for import and server to start the
@-Djava.system.class.loader=com.goldencode.p2j.classloader.MultiClassLoad... Ovidiu Maxiniuc
03:06 PM Feature #4011: database/persistence layer performance improvements: Eric,
I committed r11412. The changes include:
* I fixed the reported issue. It was caused by the @key@ being dif... Ovidiu Maxiniuc
05:20 AM Feature #4011: database/persistence layer performance improvements: Ovidiu, when I try to log into Hotel GUI embedded mode (or run any test case) with rev 14111, I get this:... Eric Faulhaber
08:18 PM Feature #4011: database/persistence layer performance improvements: Eric Faulhaber wrote:
>> I noticed your TODO in DatabaseManager. I am going to address is immediately as this is use... Ovidiu Maxiniuc

04/21/2020

08:07 AM Feature #3814: more schema metadata: At this moment I'm using the current approach based on @metadata@ in @p2j.cfg.xml@. I believe that it will be easy to... Igor Skornyakov
08:02 AM Feature #3814: more schema metadata: We can leave behind a conversion artifact for this, since the dynamic queries are only processed at runtime this shou... Greg Shah
03:47 AM Feature #3814: more schema metadata: Greg/Igor: a VST can be used from dynamic queries, too. And this will leave nothing for us to determine via the stan... Constantin Asofiei
06:08 AM Feature #4011: database/persistence layer performance improvements: Ovidiu Maxiniuc wrote:
> I merged in my changes related to import and a few other fixes. Latest revision of 4011a is... Eric Faulhaber

« Previous

Also available in: Atom

Project

General

Profile

FWD » Core Development » Database

Activity

Activity

05/20/2020

05/19/2020

05/18/2020

05/16/2020

05/15/2020

05/14/2020

05/13/2020

05/12/2020

05/11/2020

05/10/2020

05/09/2020

05/08/2020

05/07/2020

05/06/2020

05/05/2020

05/01/2020

04/30/2020

04/29/2020

04/28/2020

04/27/2020

04/25/2020

04/24/2020

04/23/2020

04/22/2020

04/21/2020