Activity
From 10/07/2020 to 11/05/2020
11/05/2020
- 10:02 AM Feature #1587: implement full support for word indexes
- Greg Shah wrote:
> As of this moment, we don't need to implement our own word break tables. We can avoid this featu... - 09:53 AM Feature #1587: implement full support for word indexes
- I like this Russian saying "shooting a canon at sparrows".
As of this moment, we don't need to implement our own w... - 09:44 AM Feature #1587: implement full support for word indexes
- Greg Shah wrote:
> > I have no experience with full-text search support in SQL databases, but after a quick look at ... - 09:14 AM Feature #1587: implement full support for word indexes
- The specific solution does not matter to me so long as it is compatible and fast. Anything (Igor's idea or the built...
- 09:13 AM Feature #1587: implement full support for word indexes
- > I have no experience with full-text search support in SQL databases, but after a quick look at the documentation, I...
- 08:15 AM Feature #1587: implement full support for word indexes
- Greg Shah wrote:
> Some useful references:
>
> * "ElasticSearch":https://en.wikipedia.org/wiki/Elasticsearch - th...
11/04/2020
- 12:43 PM Feature #4996 (WIP): Integrate hash indexes in H2 temp-tables
- 09:24 AM Bug #4994: NPE in AdaptiveQuery when loading null data for an outer join
- When a @CompoundQuery@ has a component using the OUTER JOIN option, we try to load data via the @AdaptiveQuery.load(O...
- 09:13 AM Bug #4994 (Closed): NPE in AdaptiveQuery when loading null data for an outer join
- 03:53 AM 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...
10/30/2020
- 01:14 PM Feature #1587: implement full support for word indexes
- The @TEMP-TABLE:ADD-NEW-INDEX@ method depends on this, as noted in #4397. When task is finished, the word indexes mus...
- 01:05 PM Feature #4397: add database attrs, methods and options
- >> TEMP-TABLE:ADD-NEW-INDEX() method
>
> Not touched. (It is currently marked as partial because it doesn't handle ... - 11:53 AM Feature #4397: add database attrs, methods and options
- Status of issues in 4397a/11776.
> * @BUFFER:LAST-BATCH@ attribute
Done 99%. There is one edge-case where a "look-a... - 07:12 AM 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... - 07:08 AM 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...
10/29/2020
- 12:11 PM 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 ...
- 07:06 AM 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 ...
- 05:34 AM 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...
10/28/2020
- 02:02 PM Feature #4055: optimize temp-table output parameter copying
- Insofar as this affects your design decisions, please note that we do not actually create unique indices for temp-tab...
10/27/2020
- 08:42 AM Feature #4055: optimize temp-table output parameter copying
- I have experimented some scenarios both in 4GL and FWD and I wanted to point out some hot-spots and maybe some optimi...
10/26/2020
- 09:46 AM Feature #1587: implement full support for word indexes
- Creates task branch 1587a
10/23/2020
- 11:22 AM Feature #4980 (New): Investigate the impact of TOAST manipulation in PotgreSQL engine
- PostgreSQL has a manager (named TOAST) which ensures that all texts wider than TOAST_TUPLE_THRESHOLD (usually 2kB) ar...
10/20/2020
- 01:21 PM Bug #4825: OutputTableHandleCopier dynamically defines destination temp-table
- Attached is the patch which instruments the @OutputTableHandleCopier.finished@ method via JMX bean.
10/19/2020
- 04:29 PM Bug #4825: OutputTableHandleCopier dynamically defines destination temp-table
- Eric Faulhaber wrote:
> A useful first step to help prioritize this optimization would be to instrument this code ...
10/15/2020
- 02:50 AM Bug #4945: Optimize indexes for H2 dialect
- Ovidiu, there is no H2 dedicated repository yet. My patch on H2 is not safe, so I didn't worry about a repository jut...
10/14/2020
- 07:12 PM Bug #4945: Optimize indexes for H2 dialect
- I finished the solution for avoiding re-sorting the data if a reversed index is detected. I have chosen the solution ...
10/09/2020
- 05:20 PM Bug #4945: Optimize indexes for H2 dialect
- Eric Faulhaber wrote:
> OK, as soon as you are comfortable with your FWD-only changes, please commit them.
Done, se... - 04:40 PM Bug #4945: Optimize indexes for H2 dialect
- OK, as soon as you are comfortable with your FWD-only changes, please commit them.
As to the H2 changes, please DO... - 04:27 PM Bug #4945: Optimize indexes for H2 dialect
- I will answer in reverse order.
> Is the first item in #4945-15 something that stands on its own?
Yes, I adjusted... - 03:53 PM Bug #4945: Optimize indexes for H2 dialect
- Ovidiu, do you expect to have any update today? Is the first item in #4945-15 something that stands on its own?
10/08/2020
- 06:36 PM Bug #4945: Optimize indexes for H2 dialect
- Constantin Asofiei wrote:
> Without the @_multiplex@ first at the ORDER BY, the WHERE will choose a different index;...
10/07/2020
- 01:43 AM Bug #4945: Optimize indexes for H2 dialect
- Eric Faulhaber wrote:
> Constantin, do you remember why we moved @_multiplex@ to the front of index definitions and ... - 01:40 AM Bug #4945: Optimize indexes for H2 dialect
- From my debugging of the AdaptiveQuery, in H2 the LIMIT is applied at the fetch, and not after re-sort, if the fetch ...
Also available in: Atom