State length for raddock

[Adam Hubble]

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... 

[Obi-Wan Kenobi]

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.).

[Adam Hubble]

Thanks!