Question
National Account Service Company
US
Last activity: 19 May 2021 3:53 EDT
Exposing a DB column with 20000 characters
We have a requirement where the comments can be entered upto 20000 characters. We created a property for capturing the comments. Is it ok to optimize that property (pyNote property) to a db column with varchar (20000)?.
Are there performance implications with having a column with 20000 characters that we should be aware of?
Updated: 19 May 2021 3:53 EDT
Pegasystems Inc.
IN
@SwaminathanG8419 I don't think databases would allow having these many characters. There are limits on how long an entire row can be. For instance, as per this article - https://www.tutorialspoint.com/What-is-the-maximum-length-of-MySQL-VARCHAR-column, 21000 is max row size if you are using UTF8 encoding which is default in Pega. If you assign, 20000 to your comments columns, other columns may end with just 1000 characters.
Have you ruled out storing the comments in BLOB column altogether?