Hi all. I'm trying to find the best way to query a large collection of documents, which include a byte. I need a fast way to find the most recent Timestamp filtered by an Id
I currently have
var qry = col.Query().
Where(x => x.SensorId == sensorId).
OrderByDescending(x => x.TimeStampUTC).
i've got 2 questions:
is there a way to influence the file size of the DB. My database is 780MB big compared to 350MB for the same data/index in sqlite
i am inserting 1.8 million documents/rows having 4 fields, the _id and 3 others which need to be indexed.
inserting them in bulks of 100k and then doing an EnsureIndex on the 3 fields gives me a runtime of roughly 5 minutes
having the EnsureIndex in place before i start the bulkinsert gives me 9:30 minutes
Is there a difference in query performance, foing it with method 1 or 2?
I am getting "The process cannot access the file because it is being used by another process." exception in windows service while using litedb 5.0.8 version.
You will need to add connection=shared in the connection string