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 minutesIs 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
Refer mbdavid/LiteDB#1453
Falha ao Gravar Registro -[10], [System.UnauthorizedAccessException: O acesso ao caminho 'Global\FFBAB3EC7319D08E60E44B4EA5FA83570C27F817.Mutex' foi negado. || em System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) || em System.Threading.Mutex.MutexTryCodeHelper.MutexTryCode(Object userData) || em System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData) || em System.Threading.Mutex.CreateMutexWithGuaranteedCleanup(Boolean initiallyOwned, String name, Boolean& createdNew, SECURITY_ATTRIBUTES secAttrs) || em System.Threading.Mutex..ctor(Boolean initiallyOwned, String name, Boolean& createdNew, MutexSecurity mutexSecurity) || em LiteDB.SharedEngine..ctor(EngineSettings settings) || em LiteDB.ConnectionString.CreateEngine() || em LiteDB.LiteDatabase..ctor(ConnectionString connectionString, BsonMapper mapper) || em RegStatusMonitor.Status.gravaPing(Int32 codigo_status, String valor_status)]
Hi there, I have a problem while loading a nested object from the DB:
public class Audio
{
public Guid Id { get; }
public string Path { get; }
public Audio(Guid id, string path)
{
Id = id;
Path = path;
}
}
public class Sound
{
public Guid Id { get; }
[BsonField("audio")]
[BsonRef("audio")]
public Audio Audio { get; set; }
public Sound(Guid id, Audio audio)
{
Id = id;
Audio = audio;
}
}
ILiteCollection<Sound> soundCollection = db.GetCollection<Sound>("sound");
soundCollection.Insert(new Sound(Guid.NewGuid(), new Audio(Guid.NewGuid(), "path1")));
soundCollection.Insert(new Sound(Guid.NewGuid(), new Audio(Guid.NewGuid(), "path2")));
List<Sound> allSounds = new List<Sound>();
allSounds.AddRange(soundCollection.FindAll().ToList()); // Error hereException:
Prism.Ioc.ContainerResolutionException
HResult=0x80131500
Message=An unexpected error occurred while resolving 'SoundMod.ViewModels.MainWindowViewModel'
Source=Prism.Unity.Wpf
StackTrace:
at Prism.Unity.UnityContainerExtension.Resolve(Type type, ValueTuple`2[] parameters)
at Prism.Unity.UnityContainerExtension.Resolve(Type type)
at Prism.PrismInitializationExtensions.<>c.<ConfigureViewModelLocator>b__0_0(Object view, Type type)
at Prism.Mvvm.ViewModelLocationProvider.AutoWireViewModelChanged(Object view, Action`2 setDataContextCallback)
at Prism.Mvvm.ViewModelLocator.AutoWireViewModelChanged(DependencyObject d, DependencyPropertyChangedEventArgs e)
at System.Windows.DependencyObject.OnPropertyChanged(DependencyPropertyChangedEventArgs e)
at System.Windows.FrameworkElement.OnPropertyChanged(DependencyPropertyChangedEventArgs e)
at System.Windows.DependencyObject.NotifyPropertyChange(DependencyPropertyChangedEventArgs args)
at System.Windows.DependencyObject.UpdateEffectiveValue(EntryIndex entryIndex, DependencyProperty dp, PropertyMetadata metadata, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType)
at System.Windows.DependencyObject.SetValueCommon(DependencyProperty dp, Object value, PropertyMetadata metadata, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType, Boolean isInternal)
at System.Windows.DependencyObject.SetValue(DependencyProperty dp, Object value)
at Prism.Mvvm.ViewModelLocator.SetAutoWireViewModel(DependencyObject obj, Nullable`1 value)
at Prism.Common.MvvmHelpers.AutowireViewModel(Object viewOrViewModel)
at Prism.PrismApplicationBase.Initialize()
at Prism.PrismApplicationBase.InitializeInternal()
at Prism.PrismApplicationBase.OnStartup(StartupEventArgs e)The problem seems to be that the constructor of Sound has Audio as a parameter, so how can I make it work?
How can I make LiteDB return a List<Sound> that also retrieves and auto-generates from the DB the Audio object that each Sound object contains?
1 reply
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.
Are you running multiple instances of your app? Or are you using LiteDB Studio to test your app? Make sure if you are doing either of those things to set the connection type to "shared" in the connection string, so that after each intercation with the DB the connection is closed. That way you can have multiple connections to the same .db file: https://www.litedb.org/docs/connection-string/
I wonder if anyone has ideas on my issue. A user runs my first application in admin mode, which creates my LiteDB with admin rights. Then in a second application (where they user cannot run the application in admin mode) they are unable to access the DB due to permission issues. Is there anything I can do on DB creation to change this? Or do I need to create the DB normally then find an alternate way of changing the file permissions?
Is the file being created in a protected folder? Try creating the .db file somewhere every user can access it
GROUP BY (YEAR(Time)100 + MONTH(Time))100 + DAY(Time)" to a similar query made with c# "var query = LogExTable.Query().GroupBy(BsonExpression.Create("((YEAR($.Time)100 + MONTH($.Time))100 + DAY($.Time))")).Select(BsonExpression.Create("@Key AS $.Time")).ToList();" I know that the Select Expression is Wrong
Hi All, I am investigating LiteDB for one of the use case and have few questions
1) DB library supports multi threading or not and what level of locking is supported, is it db level or table/collection level or record level.
2) Does it support transactions like commit or rollback operations?
3) Does it support indexes? if index is supported how much memory does it consume and how much disk space it consumes?
4) DB should be reliable, sudden crash of process should not result in DB file corruption.
5)startup time of DB must be within 1-5secs
6) DB library foot print should be between 2MB to 25MB ( binary file size and when loaded in to memory ideal case: it shd consume not more than 2MB)
b. Measure the increase in memory size when a model is loaded. Say a model file is 2MB then memory image of the same should not more than 10MB.
7) DB logs enable/disable should be there
Configurazione dati_db = GetDbTable()
.FindOne(x =>
string.Compare(x.Password, password, StringComparison.OrdinalIgnoreCase) == 0 &&
(string.Compare(x.UserName, user, StringComparison.OrdinalIgnoreCase) == 0 || string.Compare(x.Email, email, StringComparison.OrdinalIgnoreCase) == 0));