topic Saving complex variables as JSON string in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/saving-complex-variables-as-json-string/m-p/185408#M138538 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>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!!</SPAN></BODY></HTML> Thu, 07 Aug 2014 18:05:56 GMT satramalin 2014-08-07T18:05:56Z Saving complex variables as JSON string https://connect.hyland.com/t5/alfresco-archive/saving-complex-variables-as-json-string/m-p/185408#M138538 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 performanc Thu, 07 Aug 2014 18:05:56 GMT https://connect.hyland.com/t5/alfresco-archive/saving-complex-variables-as-json-string/m-p/185408#M138538 satramalin 2014-08-07T18:05:56Z Re: Saving complex variables as JSON string https://connect.hyland.com/t5/alfresco-archive/saving-complex-variables-as-json-string/m-p/185409#M138539 <HTML><HEAD></HEAD><BODY><SPAN>The downside is that the variable won't be searchable since they will be stored as bytes.</SPAN><BR /><BR /><SPAN>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).</SPAN></BODY></HTML> Tue, 19 Aug 2014 08:54:59 GMT https://connect.hyland.com/t5/alfresco-archive/saving-complex-variables-as-json-string/m-p/185409#M138539 jbarrez 2014-08-19T08:54:59Z