I am involved in project where we have to store very long string in varchar column (
varchar(max)). Due to this case have to questions:
- This column is one of other 40 columns in table (but only this has to be varchar(max)). To this table we will insert approximately 300 records per second. What is more this table will be partitioned for 32 partitions. What will be a good practise ?:
- Leave this column in this table
- Create new table with this column and ID (
FK(references to main table)) ?
- Any other approach ?
- Data in this column will be stored in netstring format. Moreover we will have to retrieve some specific field from this long string from this column. What is the best and most efficient way to do that ? Is it s good idea to for example to parse this
Thank you in advance for your answers :)