If number of column decreases in the container will it be increase SELECT query

Home Forums Developer Forum If number of column decreases in the container will it be increase SELECT query

This topic contains 1 reply, has 2 voices, and was last updated by  Owen 5 months, 2 weeks ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #20453 Reply

    TSIP

    Hello,

    Please let me know breifly which container will give more performance when we execute SELECT *from Iinfo; query.
    Iinfo{
    String Name; /*row key */
    int size; /* INTEGER */
    int height;/* INTEGER */
    int width;/* INTEGER */
    int code;/* INTEGER */
    }

    Iinfo{
    string Name; /*row key STRING*/
    int Dim[4]; /* Index 0 –> size, Index 1–> height, Index 2–>Width and 3–>code, INTEGER_ARRAY */
    }

    Thanks and regard
    Devaraju M K

    #20463 Reply

    Owen
    Keymaster

    The two schemas will have identical performance. Performance may be affected if you set other columns to be secondary indices.

    GridDB works best using many containers so splitting data between different containers can be beneficial if your data model supports it.

Viewing 2 posts - 1 through 2 (of 2 total)
Reply To: If number of column decreases in the container will it be increase SELECT query
Your information: