Database with a table containing 700 million records
.net, c#, database, sql-server, sqlite
Solution
Go for SQL Server for sure. 700 million records in SQLite is too much.
With SQLite you have following limitation
- Single process write.
- No mirroring
- No replication
Check out this thread: What are the performance characteristics of sqlite with very large database files?
Problem
Possible Duplicate: What are the performance characteristics of sqlite with very large database files? I want to create a .Net application that uses a database that will contain around 700 million records in one of its tables. I wonder if the performance of SQLite would satisfy this scenario or should I use SQL Server. I like the portability that SQLite gives me.