You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Maksim Timonin (Jira)" <ji...@apache.org> on 2021/07/05 08:29:00 UTC
[jira] [Commented] (IGNITE-13364) Improve index inline defaults
[ https://issues.apache.org/jira/browse/IGNITE-13364?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17374663#comment-17374663 ]
Maksim Timonin commented on IGNITE-13364:
-----------------------------------------
[~korlov] thanks!
[~slukyanov], [~tledkov-gridgain] could you please have a look too?
> Improve index inline defaults
> ------------------------------
>
> Key: IGNITE-13364
> URL: https://issues.apache.org/jira/browse/IGNITE-13364
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Evgeniy Rudenko
> Assignee: Maksim Timonin
> Priority: Major
> Fix For: 2.12
>
> Time Spent: 50m
> Remaining Estimate: 0h
>
> We need to improve how inline size is calculated by default for variable-length types.
> Currently if a varlength type is encountered inline size just defaults to 10, which is almost always not enough.
> A more sensible behavior would be the following:
> 1. Add a fixed default to the inline size calculation for every variable-length type. For example, if the default inlined size for a string is 10 then an index like (INT, VARCHAR, VARCHAR, INT) should have inline size default as 5 + 10 + 10 + 5 = 30 (5 for each int, 10 for each string).
> 2. Add special support for VARCHAR_FIXED - if a VARCHAR has known length then that length is used for inline size calculation
--
This message was sent by Atlassian Jira
(v8.3.4#803005)