FWD » Core Development » Database

03/07/2024

02:44 PM Bug #7645 (WIP): Simplify _meta database initialization by removing <schema>.meta.xml resource

Review of 7645a/15017.
So far, so good. I am OK with the revision, I like the splitting of the code in very specif... Ovidiu Maxiniuc

02:49 AM Bug #8249: Introduce a fast fill method to optimize Dataset.fill

I've committed the patch to 8363a rev 15038. Constantin Asofiei

02:45 AM Bug #8249: Introduce a fast fill method to optimize Dataset.fill

Hmm, I am not 100% familiar of how the FILL works. I was supposing it can take any arbitrary query to do the fill. So... Alexandru Lungu

02:32 AM Bug #8249: Introduce a fast fill method to optimize Dataset.fill

Alexandru, using the patch helps #8363. But, I wonder if your patch is just something to do the same thing as inject... Constantin Asofiei

03/05/2024

10:09 AM Bug #7474: FindQuery provides the wrong result because the record is not updated in the database

I've hit the issue while working on intra session dirty share - in case record is modified in a transaction different... Tomasz Domin

06:01 AM Bug #8249: Introduce a fast fill method to optimize Dataset.fill

Constantin, this is the patch I used in an attempt to optimize @ProgressiveResults@ into @ScrollingResults@ when usin... Alexandru Lungu

03/04/2024

04:06 PM Bug #8101 (Closed): Issue with temp-table defined as reference-only

Fixed in trunk rev 15028 via 8329a. Constantin Asofiei

10:56 AM Bug #7645 (Review): Simplify _meta database initialization by removing <schema>.meta.xml resource

Alexandru Lungu

03:38 AM Bug #7645: Simplify _meta database initialization by removing <schema>.meta.xml resource

Eduard Soltan wrote:
> Eric Faulhaber wrote:
> > Eduard, is this ready for review? Is there anything left to do on ... Eduard Soltan

03:37 AM Bug #7645: Simplify _meta database initialization by removing <schema>.meta.xml resource

Eric Faulhaber wrote:
> Eduard, is this ready for review? Is there anything left to do on this, other than regressio... Eduard Soltan

09:08 PM Bug #7645: Simplify _meta database initialization by removing <schema>.meta.xml resource

Eduard, is this ready for review? Is there anything left to do on this, other than regression testing? Eric Faulhaber

02/29/2024

04:13 AM Bug #7645: Simplify _meta database initialization by removing <schema>.meta.xml resource

Committed on 7645a. revision 15017.
I moved the logic from metaschema.xml into MetadataManger class, and created a... Eduard Soltan

03:21 AM Bug #7645 (WIP): Simplify _meta database initialization by removing <schema>.meta.xml resource

Eduard Soltan

02/20/2024

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

After testing POC with JMXs I found out that @(select count()) = 1@ is used often and a lot more than with @FIRST@ or... Dănuț Filimon

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

I've made a few examples to check if there are other methods used and got the following:
* @CAN-FIND(pt1)@ generated... Dănuț Filimon

02/19/2024

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

Checking for @exists@ in the FQL seems like a reasonable approach. Right now, it is only used to implement server-sid... Eric Faulhaber

02/15/2024

04:23 AM Feature #6628 (WIP): port PostgreSQL native user defined functions to MariaDB

Eric Faulhaber wrote:
> OK, please go ahead and implement my suggestions. That is:
>
> * augment @FQLPreprocessor... Dănuț Filimon

02/14/2024

07:30 AM Feature #6720: lazy hydration

I changed @BaseRecord.copy@, to set @hydrator@ and @liveProps@ of the new record ... Eduard Soltan

04:02 AM Feature #6720: lazy hydration

Lets go ahead with some statistics. From where is @getData@ called and how many times. Please find the back traces of... Alexandru Lungu

02:09 AM Feature #6720: lazy hydration

On delete of a temporary buffer and a deleted buffer is placed in before table.
But to make this copy a snapshot o... Eduard Soltan

02/13/2024

02:22 PM Feature #6720: lazy hydration

Short update from a live discussion with Eduard: the regression seems to be related with the @BaseRecord.getData@ cal... Alexandru Lungu

02/12/2024

02:39 AM Bug #7496: finish support for query:forward-only attribute

Rebased *7496a* with *trunk/rev.14981*. *7496a* is now at revision *14991*. Dănuț Filimon

02:29 AM Bug #7334 (Test): Reclaim used sessions to improve performance

Dănuț Filimon

02:29 AM Bug #7334 (Internal Test): Reclaim used sessions to improve performance

Alexandru Lungu wrote:
> This reached trunk a while ago. Is there anything left on this task? If not, please move it... Dănuț Filimon

02:26 AM Bug #7334: Reclaim used sessions to improve performance

This reached trunk a while ago. Is there anything left on this task? If not, please move it to test. Alexandru Lungu

02/09/2024

10:36 AM Bug #7924: add support for creating an empty database

Issue has been fixed in *7924a.rev.14794*. All field types can be augmented with @__null@ for @MariaDbDialect@ when t... Dănuț Filimon

04:57 AM Bug #8259: Reduce the work done by PreselectQuery.coreFetch

Alexandru Lungu wrote:
> Eduard Soltan wrote:
> > For now in we assign to @updateLock@ the following expression: @u... Eduard Soltan

04:04 AM Bug #8259: Reduce the work done by PreselectQuery.coreFetch

Eduard Soltan wrote:
> For now in we assign to @updateLock@ the following expression: @updateLock = (lt != LockType.... Alexandru Lungu

03:58 AM Bug #8259: Reduce the work done by PreselectQuery.coreFetch

For now in we assign to @updateLock@ the following expression: @updateLock = (lt != LockType.NONE);@.
I think that... Eduard Soltan

03:59 AM Bug #7999: FWD does not honor FIELDS/EXCEPT at dynamic queries

Ovidiu Maxiniuc wrote:
> ** line 1368: @byLegacyName()@ requires that the argument to be normalized (lowercase). Yo... Eduard Soltan

02/08/2024

02:14 PM Bug #8249: Introduce a fast fill method to optimize Dataset.fill

I discussed with Alexandru [ad] and there is a reasonable observation that the fill queries are usual @AdaptiveQuery@... Alexandru Lungu

09:20 AM Bug #8249: Introduce a fast fill method to optimize Dataset.fill

A little note:
@DataSet.fill@ calls @BufferImpl.fill@ which calls @FillWorker.fill@ (class inside @BufferImpl@), whi... Alexandru Donica

11:00 AM Bug #7924: add support for creating an empty database

Dănuț,
@sql_only_user__null@ must be generated.
This thing seemed familiar to me. I did a bit of research and ... Ovidiu Maxiniuc

10:12 AM Bug #7999: FWD does not honor FIELDS/EXCEPT at dynamic queries

Review of 7999a/14954-14958.
The code looks promising, most of the issues below are low priority. but there are a co... Ovidiu Maxiniuc

09:08 AM Bug #8259: Reduce the work done by PreselectQuery.coreFetch

Eduard, this basically means that the condition in #8259-2 is incorrect.
Please post here a cut-out to the problem... Alexandru Lungu

08:49 AM Bug #8259: Reduce the work done by PreselectQuery.coreFetch

Alexandru Lungu wrote:
> I wonder if NO-LOCK to SHARE-LOCK is considered an lock update.
It is. Any change in loc... Eric Faulhaber

08:03 AM Bug #8259: Reduce the work done by PreselectQuery.coreFetch

I wonder if NO-LOCK to SHARE-LOCK is considered an lock update. Alexandru Lungu

07:20 AM Bug #8259: Reduce the work done by PreselectQuery.coreFetch

Alexandru Lungu wrote:
> My whole concern here is that we do an extra session cache look-up for almost any record ... Eduard Soltan

05:55 AM Bug #8259: Reduce the work done by PreselectQuery.coreFetch

Eduard detected recently that there is some work being done in @PreselectQuery.coreFetch@ regarding an extra fetch.
... Alexandru Lungu

04:29 AM Bug #8259 (New): Reduce the work done by PreselectQuery.coreFetch

Alexandru Lungu

09:01 AM Bug #7252: Use direct-access to support for-each queries without WHERE and BY clauses

In terms of JMX, results look promising. Out of a million of "Select all" type of queries, the @DirectAccess@ method ... Radu Apetrii

06:42 AM Bug #7252: Use direct-access to support for-each queries without WHERE and BY clauses

Radu, if the solution is stable. Lets get some profiling results asap.
Please go in-depth with some JMX to check the... Alexandru Lungu

06:35 AM Bug #7252: Use direct-access to support for-each queries without WHERE and BY clauses

Alexandru Lungu wrote:
> You can have compound queries. A component can be instantiated as an @AdaptiveQuery@. See @... Radu Apetrii

05:24 AM Bug #7252: Use direct-access to support for-each queries without WHERE and BY clauses

You can have compound queries. A component can be instantiated as an @AdaptiveQuery@. See @for each tt, each tt2@, as... Alexandru Lungu

05:09 AM Bug #7252: Use direct-access to support for-each queries without WHERE and BY clauses

Alex/Greg: Are there any other ways of generating a "Select all" type of *static* query that turns into an @AdaptiveQ... Radu Apetrii

07:19 PM Bug #7252: Use direct-access to support for-each queries without WHERE and BY clauses

I've committed to:
* *7252b rev. 14934* a change for better handling of index choosing in @AdaptiveQuery.getAllLazyD... Radu Apetrii

02/07/2024

11:53 AM Bug #7252: Use direct-access to support for-each queries without WHERE and BY clauses

Greg Shah wrote:
> It seems better to "remember" this information than to calculate it at runtime.
I'll add this id... Radu Apetrii

04:46 AM Bug #8251: Fine tune CompoundQuery optimization when contains clauses are used

This is a follow up of #8246.
Compound queries using @contains@ clause are no longer optimized:
* Check if this c... Alexandru Lungu

04:43 AM Bug #8251 (New): Fine tune CompoundQuery optimization when contains clauses are used

Alexandru Lungu