使用哪个数据库？ [英] Which database to use?

问题描述

嗨。，



我编写了一个从串口读取数据并将其存储在数据库中的应用程序。我想知道哪个数据库最好用。数据速率为9600，接收的数据为每秒20个数据。我需要运行应用程序10个小时。



我用C＃编写了应用程序。我试过sql server express和sqllite，它没有很好地处理这么多数据。



请求任何数据库建议





提前感谢

Hi.,

I have written an application to read data from serial port and store it in database. I want to know which database is best to use. The data rate is 9600, The data received is 20 data per second. I need to run the application for 10 hours.

I have written application in C#. I tried sql server express and sqllite which is not handling so much data well.

requesting for any suggestions for database


thanks in advance

推荐答案

可能不能处理如此多的数据问题更多的是你的功能代码比数据库：9600波特连接非常慢 - 它小于1KB /秒，小于可接受（但很慢）ADSL连接的1/1000。并且有很多系统以这些速率获取数据，实际上要快得多。



所以看看你的代码，计算时间，找出什么您当前的数据吞吐量实际上是：用最基本的表单替换数据库并将其直接写入二进制文件进行测试。



然后当你有一些数字时，你可以开始查看你的瓶颈在哪里 - 但立即指责那些对他人有效的数据库系统不太可能给你带来任何好结果！

Probably, the "not handling so much data well" problem is more a function of your code than or the database: a 9600 baud connection is pretty slow - it's less than 1KB/sec which is less than 1/1000th of an acceptable (but slow) ADSL connection. And there are plenty of systems out there taking data at those rates, and indeed much, much faster.

So look at your code, time it, and work out what your current data throughput actually is: replace the database with the most basic form and write it direct to a binary file for testing.

Then when you have some numbers, you can start looking at where your bottleneck is - but immediately blaming database systems that work fine for others is unlikely to get you any good results!

这篇关于使用哪个数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！