3

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.

Saw
  • 6,199
  • 11
  • 53
  • 104

1 Answers1

3

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

Community
  • 1
  • 1
Mare Infinitus
  • 8,024
  • 8
  • 64
  • 113