Agree. On Mon, May 7, 2018 at 5:20 PM, Dmitriy Setrakyan <dsetrak...@apache.org> wrote:
> On Mon, May 7, 2018 at 2:09 AM, Vladimir Ozerov <voze...@gridgain.com> > wrote: > > > Hi Dima, > > > > Update with indexes would definitely be slower than update without them. > > The question is how much slower. For now the slowdown comes mostly from > > excessive data page reads ([1] and [2] in my previous email) leading to > > page evictions and additional IO. To the contrast, usually only a single > > page write is needed to update an index. Correct index implementation > ([1] > > and [2] from previous email) would eliminate data page reads altogether > and > > should give dramatic speedup. > > > > Sounds great. The changes you are suggesting should give us a great > performance boost. Hopefully they should not take too long to implement. > > Regardless, once you are done, we should still perform a benchmark with > persistence indexes vs memory-only indexes. If memory-only will be more > than 20% faster, we should still implement it. > > D. >
