General

Profile

Adrian Lungu's activity

From 10/28/2020 to 11/26/2020

11/26/2020

12:26 PM Database Feature #4055: optimize temp-table output parameter copying
I committed some changes for signature building and matching to 3821c/rev. 11839:
* *Enhanced unique constraints c... Adrian Lungu

11/25/2020

07:14 AM Database Feature #3958 (WIP): BUFFER-COPY optimization
Adrian Lungu
07:11 AM Database Feature #4055: optimize temp-table output parameter copying
I committed the current implementation of DMO signature to 3821c/rev. 11835, as I reached a stable implementation, wh... Adrian Lungu

11/24/2020

05:39 AM Database Feature #4055: optimize temp-table output parameter copying
Eric Faulhaber wrote:
> Agreed. Note that for temp-tables, the MANDATORY attribute can be dropped from the signature... Adrian Lungu

11/23/2020

01:19 PM Database Feature #4055: optimize temp-table output parameter copying
These are the first steps in introducing the DMO structure signature according to #4011-774. I posted a diff containi... Adrian Lungu

11/21/2020

09:49 AM Database Feature #4055: optimize temp-table output parameter copying
Eric Faulhaber wrote:
> Revision 10743 is quite old and I'm not sure to what that comment refers.
After #2134, th... Adrian Lungu

11/20/2020

12:45 PM Database Feature #4055: optimize temp-table output parameter copying
Never mind, according to trunk/rev. 10743:... Adrian Lungu
12:38 PM Database Feature #4055: optimize temp-table output parameter copying
I might misunderstood. Only persistent tables can be de-normalized through schema hints individually. For temporary t... Adrian Lungu
12:28 PM Database Feature #4055: optimize temp-table output parameter copying
If I understand correctly, the de-normalization feature in #2134 adds the extent fields (eventually with custom names... Adrian Lungu
08:32 AM Database Feature #5003: Enhance performance of H2 sequences
The "method representation" has been introduced in 3821c/rev 11824 (@TemporaryBuffer@) and in 3821c/rev 11830 (@P2JH2... Adrian Lungu
08:25 AM Database Feature #4996: Integrate hash indexes in H2 temp-tables
I tried out changing tree indexed primary keys to hash indexed primary keys (recid). The modification doesn't change ... Adrian Lungu

11/18/2020

12:38 PM Database Feature #4055: optimize temp-table output parameter copying
Committed as 3821c/rev. 11824. the modifications partially described in #4055-64. This also contains the #5003-2 opti... Adrian Lungu

11/17/2020

06:39 AM Database Feature #5003: Enhance performance of H2 sequences
The @Sequence.DEFAULT_CACHE_SIZE@ optimization was committed in fwd-h2/rev. 4. On a singular testcase (one million @n... Adrian Lungu
04:25 AM Database Feature #4055: optimize temp-table output parameter copying
Eric Faulhaber wrote:
> I do think we should be consistent with H2's conventions, however, in case we decide to ask ... Adrian Lungu

11/16/2020

03:13 AM Database Feature #4055: optimize temp-table output parameter copying
I was trying to optimize a basic temp-table copy testcase (simple copy with @INSERT INTO SELECT FROM@). I detected a ... Adrian Lungu

11/13/2020

04:01 AM Database Feature #4996: Integrate hash indexes in H2 temp-tables
Not really. H2 prefers a more "general use" index for the primary key - a tree index. This is because it prefers fast... Adrian Lungu

11/12/2020

04:24 AM Database Feature #4996: Integrate hash indexes in H2 temp-tables
#4996-4 is quite on spot. I may add that H2 allows hash indexes for fields which are not unique, but the queried reco... Adrian Lungu

11/10/2020

07:10 AM Database Feature #5003: Enhance performance of H2 sequences
There is a @Sequence.DEFAULT_CACHE_SIZE@ which defaults on 32. This refers to how often the sequence is flushed (and ... Adrian Lungu
07:08 AM Database Feature #5003 (WIP): Enhance performance of H2 sequences
Adrian Lungu

11/06/2020

04:31 AM Database Feature #4996: Integrate hash indexes in H2 temp-tables
The goal of this task is to explore hash index potential uses for the H2 temp-tables. For example, this can boost the... Adrian Lungu

11/04/2020

12:43 PM Database Feature #4996 (WIP): Integrate hash indexes in H2 temp-tables
Adrian Lungu
03:53 AM Database Feature #4055: optimize temp-table output parameter copying
Regarding @optimize extent bulk copy using insert into select from@, I found an optimization which doesn't rely anymo... Adrian Lungu

10/30/2020

07:12 AM Database Feature #4055: optimize temp-table output parameter copying
Directions for temp-table copy optimization:
* -extend the use of *insert into select from* for some cases of append... Adrian Lungu
07:08 AM Database Feature #4055: optimize temp-table output parameter copying
*Extent*: When in @insertBulk@ mode, the extents fields are copied one by one. This can be also optimized with a @in... Adrian Lungu

10/29/2020

12:11 PM Database Feature #4055: optimize temp-table output parameter copying
I will ignore #4055-60 for now, it doesn't fit my understanding of how @copy-temp-table@ is working. I will document ... Adrian Lungu
07:06 AM Database Feature #4055: optimize temp-table output parameter copying
I am a bit confused of two recently generated testcases. I tried to experiment with @copy-temp-table@ in the context ... Adrian Lungu
05:34 AM Database Feature #4055: optimize temp-table output parameter copying
Eric Faulhaber wrote:
> Each legacy temp-table index, whether it is unique or not in the legacy schema, is created w... Adrian Lungu
 

Also available in: Atom