I would like to store/read/process log data that comes from various sensors (e.g temperature, pressure) in 30 second intervals.
我想以30秒的间隔存储/读取/处理来自各种传感器（例如温度，压力）的日志数据。
The web app will show statistics and summaries of the log data.
Web应用程序将显示日志数据的统计信息和摘要。
Now I am wondering if it would be better to use a NoSQL database in this case? Or would it be better to store the information in xml files, parse it and calculate average values and other important stats and save those to a database?
现在我想知道在这种情况下使用NoSQL数据库是否更好？或者将信息存储在xml文件中，解析它并计算平均值和其他重要统计数据并将其保存到数据库中会更好吗？
Thank you for your tips
谢谢你的提示
1 个解决方案
#1
0
I assume that your workload is a one-two digit number of insertions/updates per 30 seconds and the equal order of magnitude of queries. If I'm right above then MySQL should be fine for your task.
我假设您的工作负载是每30秒插入/更新的两位数，以及相同数量级的查询。如果我在上面，那么MySQL应该适合你的任务。
#1
0
I assume that your workload is a one-two digit number of insertions/updates per 30 seconds and the equal order of magnitude of queries. If I'm right above then MySQL should be fine for your task.
我假设您的工作负载是每30秒插入/更新的两位数，以及相同数量级的查询。如果我在上面，那么MySQL应该适合你的任务。