SQLite Thread mode

[Hesmith1029]

Does anyone know what what Multi-Thread mode Photo Supreme uses in SQLite. Single Thread, Multi-Thread, or Serialized?

Resource Monitor's Wait Chain Analysis is often showing many threads hung waiting for the same other thread. It is quite common to see 8 to 12 threads waiting on the same item.

Thanks

[Hert]

Multi Threaded.
Please learn about threading in SQLite.
https://www.sqlite.org/threadsafe.html

in multi threading mode you can use an isolated connection in different threads. But SQLite does not allow multiple threads to write to the database at the same time.

[Hesmith1029]

That is the exact page I was looking at, that prompted the question. Will things work if you used Serialized mode?

[Hert]

You overlook something. SQLite supports multiple reads, not writes.

Ps. Also read the forum rules, #5