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

Posted to issues@ignite.apache.org by "Artem Budnikov (JIRA)" <ji...@apache.org> on 2018/10/16 10:57:00 UTC

[jira] [Commented] (IGNITE-9819) SQL: document recomendation to use TIMESTAMP instead of DATE

    [ https://issues.apache.org/jira/browse/IGNITE-9819?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16651486#comment-16651486 ] 

Artem Budnikov commented on IGNITE-9819:
----------------------------------------

Added a note about TIMESTAMPs and DATEs: https://apacheignite-sql.readme.io/v2.6/docs/performance-and-debugging-27

[~pgarg] please review.

> SQL: document recomendation to use TIMESTAMP instead of DATE
> ------------------------------------------------------------
>
>                 Key: IGNITE-9819
>                 URL: https://issues.apache.org/jira/browse/IGNITE-9819
>             Project: Ignite
>          Issue Type: Task
>          Components: documentation
>            Reporter: Vladimir Ozerov
>            Assignee: Artem Budnikov
>            Priority: Major
>             Fix For: 2.7
>
>
> We support both DATE (date only) and TIMESTAMP (date + time) data types. Unfortunately, DATE data type is serialized/deserialized very inefficiently, what leads to performance degradation. 
> We need to warn users in documentation, that it is better to use TIMESTAMP than DATE.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)