We are currently evaluating various data layer designs for a project.
We have JSON data (not more than few megs & less than 500 nodes all inclusive) coming in from various sources. We have finalized on 2 approaches. Also we expect not more than 500 concurrent requests.
- Store the
JSONasCLOBin DB, andpython jsonmodule to parse and extract requiredfieldsused by the web application. - Design table for the
JSON nodesand store it in a dedicatedoracle tableand retrieve for use with theweb application
Need any 3rd degree view/suggestions, before our POC and performance testing.
Thanks for your help. I know the question has broader scope but I think it is specific enough to be considered here.
UPDATE:
- We use Oracle 11g
- Requirement is not for reporting but for displaying content on the Web app
- The web app is expected to be have
10k-30k requests /day, and we would be parsing JSON for every request. So that's10k-30ktimes/day.- This is just one part of the bigger web app.
What we are trying to establish is, is it worth having 500 odd columns (many tables) vs JSON parsing which can be handled with Python dicts which are faster anyway.
Aucun commentaire:
Enregistrer un commentaire