I have a plan to migrate my app to Strapi. The app sores prices of assets in JSON format and currently it is using the MongoDB as a database.
Now I have some questions about JSON fields:
- Does the Strapi stores a JSON field in a separate .JSON file or it stores the field in database?
- I mean does requesting and editing a heavy stored JSON fields can affect on database performance?
- If it stores the field’s data in database, does it stores JSON data as a serialized string in database?
- Assume that I have a JSON field that contains an array of daily prices in 10 years. Does Strapi has an ability to take the last value in the prices array and editing it without touching the whole array data?