CODEWITHSUNDEEP
c#.netsqldatabasesqlite
Saw
Saw

Reputation: 6416

Best serverless database to be used for large static indexed data?

What is the best serverless database to use with static data to be queried in a good performance, the data will have many indexes?

I have some data that will be queried,I don't need any type of transactions or alterations on it, the data is 5.0 GB, i need it to be deployed with some app, i need 40 indexes on my columns, what is the best technoology to use, i cann't use SQL CE because of data size limitation, my suggestions are sqlite and Firebird, are there other options, what is the best, and why?

NOTE : most of indexes are on int columns and others on small string columns to be compared using (=) operator.

Upvotes: 3

Views: 652

Answers (1)

Mare Infinitus
Mare Infinitus

Reputation: 8182

I would recommend using SQLite with Transactions. Up to now I never experienced any performance issues with it, running a 1 GB database file.

Perhaps this link will help: SO on using SQLite with large datasets

SQLite has some problems with concurrency, but if you do not have lots of users, then it will be a good choice:

SQLite official When to use

and there are some restrictions, which almost never happen in productive use (e.g. 2 GB Blobs) SQlite offical Limits

Upvotes: 3

Related Questions