如何解决Sqlite数据库只读模式下多线程读取导致的锁表问题？因为我的数据库数据将不会被写入

Question

如何解决Sqlite数据库只读模式下多线程读取导致的锁表问题？

我只想读取数据..sqlite数据库未锁定。

我该怎么做呢？因为我的数据库数据将不会被写入。

var ReadConnectionString = @"Data Source=D:\Tmp\SqlSugar\Sqlite\SqlSugar5xTest001.sqlite;Version=3;Read Only=True;";

SQLite error (5): database is locked in "SELECT * FROM "TestLong" WHERE Id = 8888"
SQLite error (5): database is locked in "SELECT * FROM "TestLong" WHERE Id = 8888"
SQLite error (5): database is locked in "SELECT * FROM "TestLong" WHERE Id = 8888"
SQLite error (5): database is locked in "SELECT * FROM "TestLong" WHERE Id = 8888"
SQLite error (5): database is locked in "SELECT * FROM "TestLong" WHERE Id = 8888"
SQLite error (5): database is locked in "SELECT * FROM "TestLong" WHERE Id = 8888"
SQLite error (5): database is locked in "SELECT * FROM "TestLong" WHERE Id = 8888"
SQLite error (5): database is locked in "SELECT * FROM "TestLong" WHERE Id = 8888"
SQLite error (5): database is locked in "SELECT * FROM "TestLong" WHERE Id = 8888"
SQLite error (5): database is locked in "SELECT * FROM "TestLong" WHERE Id = 8888"
SQLite error (5): database is locked in "SELECT * FROM "TestLong" WHERE Id = 8888"
SQLite error (5): database is locked in "SELECT * FROM "TestLong" WHERE Id = 8888"
SQLite error (5): database is locked in "SELECT * FROM "TestLong" WHERE Id = 8888"

Answer 1

//(因此您提出的查询将是最有效的：) SELECT EXISTS(SELECT 1 FROM tag WHERE u_tag=“myTbl”)；

// (如果您对可移植性感到紧张，可以添加一个限制。然而，我怀疑大多数DB都会给你提供同样的短路。)SELECT EXISTS(SELECT 1 FROM myTbl WHERE u_tag="tag“LIMIT 1)；