Which database should I use for best performance
- by _simon_
Hello,
I am working in Visual Studio 2005, .NET 2.0.
I need to write an application, which listens on COM port and saves incoming data to a database. Main feature: save incoming data (series of 13-digits numbers), if this number allready exists, then mark it as double. For example, there could be these records in database:
0000000000001 OK
0000000000002 OK
0000000000002 Double
0000000000003 OK
0000000000004 OK
I could use SQL database, but I don't know if it is fast enough... Database should be able to store up to 10.000.000 records and write up to 100 records per minute (so it needs to check 100 times per minute if this record allready exists).
Which database should I use? Maybe the whole database would need to be in RAM. Where could I learn more about this?
Thanks