Which SQLite (sqlite-net-pcl) flags should I use on Xamarin.Forms?

Question

Should I use FullMutex or NoMutex in SQLite Flags? What is their purpose? And if yes, which should I use?

For now: I'm using these flags:

public static class SQLiteConstants
{
    public const SQLiteOpenFlags Flags =
        SQLiteOpenFlags.ReadWrite |
        SQLiteOpenFlags.SharedCache |
        SQLiteOpenFlags.Create |
        SQLiteOpenFlags.FullMutex;

    public static string GetDatabasePath
    {
        get => Path.Combine(FileSystem.AppDataDirectory, "UserScores.db3");
    }
}

Adrain · Accepted Answer · 2021-07-07 03:41:06Z

3

What NoMutex mean is that the new database connection will use the "multi-thread" threading mode. This means that separate threads are allowed to use SQLite at the same time, as long as each thread is using a different database connection.
What FullMutext mean is that new database connection will use the "serialized" threading mode. This means the multiple threads can safely attempt to use the same database connection at the same time. (Mutexes will block any actual concurrency, but in this mode there is no harm in trying.) So, you can choose the flag depend on your situation

edited Jul 7, 2021 at 3:41

answered Jul 7, 2021 at 3:23

Adrain

1,9441 gold badge5 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Echo Lumaque Over a year ago

sorry for the late reply, so the FullMutex is much better in terms of performance? because as you know, mobile devices has limited resources

Adrain Over a year ago

If you have no mutex and two threads use the same connection to update the same table, then either both will work or your application would fail, memory would be corrupted. If you use the default serialized (full mutex) then both will work and there will be no consequence as described above.

Collectives™ on Stack Overflow

Which SQLite (sqlite-net-pcl) flags should I use on Xamarin.Forms?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related