Storing a Large Amount of data in a tag

Summary:
I'm working on a project where I retrieve order confirmation data through a webservice call, and the information is returned to me in JSON format. The size of the order confirmations can reach up to 20MB by the end of the day, representing thousands of rows. I perform this operation daily, and the data is only relevant for a day before being replaced by the next day's data.

Question:
Can I store the JSON dump I get from my webservice in a tag? From my experience the data stored in Memory Tags are relatively small, so is dumping 20mb of data in a tag ok to do. If not what is a good way to store data like this, that gets refreshed everyday.

Store it on disk or in a database. Putting 20mb into a memory tag is probably not a good idea.

3 Likes