CODEWITHSUNDEEP
databasesql-server-ce
Semas
Semas

Reputation: 879

Alternatives to SQL Server CE?

What good alternatives are there to SQL Server CE?

I was also thinking of writing something of my own. But I don't know about performance with 40,000 - 100,000 rows.

All data will be only in string format and it will be only one column. So is it actually worth writing my own data storage?

I will not need to order or sort data in any way, just to add and remove.

Upvotes: 2

Views: 760

Answers (2)

Henk Holterman
Henk Holterman

Reputation: 273264

If you only want to store a single list of strings, and always load/save them all at once, then a simple text file will be the fastest and easiest.

As soon as you want to do queries etc it this is no longer true. 

string[] lines = System.IO.File.ReadAllLines(fileName);

Upvotes: 1

cfeduke
cfeduke

Reputation: 23226

You can use SQLite. I guess it really depends on your feature set. Are you going to be ordering the data often? Only selecting a subset? Or loading the entire thing into memory all at once for some reason?

Upvotes: 3

Related Questions