I am looking for a back-end storage for a smart environment that I am creating. Data from sensors placed in the environment will be being gathered constantly to be stored. At the same time data will be being retrieved for processing (say once every 30 seconds).
I'm not sure which would be the best form of storage from a performance point of view:
1) Storing the data for the last 24 hours in an XML file for processing (which will then update a database at the end of the 24 hours and reset).
2) Storing all the data in a database and running queries off the database every 30 seconds (query will have multiple joins)
3) Storing all the data in an XML database (not 100% sure on how these work exactly)
No comments:
Post a Comment