Question

http://www.sqlite.org/threadsafe.html 提到:

Single-thread
Multi-thread
Serialized

哪一种方式是将SOS5综合成一体?

Answer 1

附录二这是不幸的,我本希望实现帝国化。

qlite3_config(SQLITE_CONFIG_SERIALIZED)

Answer 2

https://stackoverflow.com/a/7799021/40444“https://stackoverflow.com/a7799021/40444 。

看来你可以做以下工作:

sqlite3_shutdown();
if (sqlite3_config(SQLITE_CONFIG_SERIALIZED) == SQLITE_OK) {
    NSLog(@"sqlite configured to be threadsafe);
}
sqlite3_initialize();

然而,不清楚这是否正式奏效。

Answer 3

The answer is Multi-thread. We can check by using sqlite3_threadsafe(), which returns 2.

0 - Single-thread
2 - Multi-thread
1 - Serialized

Q: @Ben Marten "unfortunately logging sqlite3_threadsafe() does not show any difference after the setting s been applied... "

A: sqlite3_threadsafe() only reports on the compile-time mutex setting of the [SQLITE_THREADSAFE] flag.

The return value of the sqlite3_threadsafe() interface is determined by the compile-time threading mode selection. If single-thread mode is selected at compile-time, then sqlite3_threadsafe() returns false. If either the multi-thread or serialized modes are selected, then sqlite3_threadsafe() returns true. The sqlite3_threadsafe() interface predates the multi-thread mode and start-time and run-time mode selection and so is unable to distinguish between multi-thread and serialized mode nor is it able to report start-time or run-time mode changes.

友情链接