You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ignite.apache.org by Ken Cheng <kc...@gmail.com> on 2019/09/22 15:11:58 UTC

Is there a way to re-set the index inline size at runtime?

per my understanding increase the index inline size can improve query
performance, so is there a way to increase the index inline size at runtime?
my guess is that drop and re-create index will cost the whole cluster a lot.
is that true?

Thanks,
Ken Cheng

Re: Is there a way to re-set the index inline size at runtime?

Posted by Ken Cheng <kc...@gmail.com>.

thank you very much!

Thanks,
Ken Cheng


On Mon, Sep 23, 2019 at 8:29 PM Igor Belyakov <ig...@gmail.com>
wrote:

> Hi,
>
> Increasing index inline size can improve performance in cases when you're
> using variable-size columns, as described here:
> https://apacheignite-sql.readme.io/docs/create-index#section-index-inlining
>
> Also modifying inline size will require entire index rebuild, which is
> equals to index recreation. Due to this, you should use DROP/CREATE
> commands for changing index inline size.
>
> Regards,
> Igor
>
> On Sun, Sep 22, 2019 at 6:12 PM Ken Cheng <kc...@gmail.com> wrote:
>
>> per my understanding increase the index inline size can improve query
>> performance, so is there a way to increase the index inline size at
>> runtime?
>> my guess is that drop and re-create index will cost the whole cluster a
>> lot.
>> is that true?
>>
>> Thanks,
>> Ken Cheng
>>
>

Re: Is there a way to re-set the index inline size at runtime?

Posted by Igor Belyakov <ig...@gmail.com>.

Hi,

Increasing index inline size can improve performance in cases when you're
using variable-size columns, as described here:
https://apacheignite-sql.readme.io/docs/create-index#section-index-inlining

Also modifying inline size will require entire index rebuild, which is
equals to index recreation. Due to this, you should use DROP/CREATE
commands for changing index inline size.

Regards,
Igor

On Sun, Sep 22, 2019 at 6:12 PM Ken Cheng <kc...@gmail.com> wrote:

> per my understanding increase the index inline size can improve query
> performance, so is there a way to increase the index inline size at
> runtime?
> my guess is that drop and re-create index will cost the whole cluster a
> lot.
> is that true?
>
> Thanks,
> Ken Cheng
>