State length for raddock

3 posts, 1 answers
  1. Adam Hubble
    Adam Hubble avatar
    74 posts
    Member since:
    Jan 2008

    Posted 18 Aug 2008 Link to this post

    Hi,

    For storing the State of a RadDock layout in a database, we have a State column of type varchar. I was just wondering what the optimum length of the datatype should be?

    I have seen various code examples on here from Telerik where the State datatype length has been varchar(1000) but also examples where varchar(MAX) has been used. What is the recommended datatype length to use in production? Good db design obviously suggests we go as small as possible but always 'big enough' so this is quite important... 
  2. Answer
    Obi-Wan Kenobi
    Obi-Wan Kenobi  avatar
    460 posts
    Member since:
    Aug 2007

    Posted 19 Aug 2008 Link to this post

    Each RadDock state string is around ~326 characters.

    If you have less than 3 RadDocks on the page  3*326 = 978 characters: You can use - varchar(1000)

    My suggestion is to use varchar(MAX) if you create something like a portal(igoogle, pageflakes etc.).
  3. Adam Hubble
    Adam Hubble avatar
    74 posts
    Member since:
    Jan 2008

    Posted 20 Aug 2008 Link to this post

    Thanks!
Back to Top