Real-time database usage

Question

Given the .NET environment with Windows CE, you can store thousands of records per second in a local database (SQL Server 2008 - Standard or CE).

What are the problems with real-time data performance in the database compared to the log file?

Answer 1

The SQL Server 2008 standard is more than capable of the insertion rates that are set. You have hardware capable of supporting it.

The question that you really need to ask is the need for a quick search of the data found?

SO- : ?

( ) , , .

open-source, MySQL .