Saving complex variables as JSON string

[satramalin]

Hi,

We have an idea to save the complex variable as a JSON string in the TEXT_ column of act_ru_variable rather than having them as a blob in act_ge_bytearray. We face some issues in rendering the blob object to the display. So, we have come up with this idea. Do you think there might be a performance issue due to this change or any other downsides in this approach.Please advise!!

[jbarrez]

The downside is that the variable won't be searchable since they will be stored as bytes.

Performance wise it could be a small hit: some database store bytes separate from the other data on disk (so they're not in the same disk sector).