Reputation: 1466
I am new to .NET and Desktop applications, I have an app with fairly big dataset about 600, 000 currently I am running with SQl Server Express, the problem is users might not have Sql Server Installed I started looking for alternatives came across SQl Server Compact But I am not sure If SQL Compact can handle 600, 000 records
any advise or help is appreciated
thanks you
Upvotes: 1
Views: 157
Reputation: 510
SQL CE can handle these many records. In one of my projects, I had one table with more than 2 million records.
Upvotes: 2