SQLite 锁定问题

在设计器环境下工作， 正常只有我一个人工作， 但发现部分数据库更新没有，查询一堆这种locked， 是否有什么设置需要处理， 若是正式环境不能更加麻烦

SQLite error (261): database is locked in "select a.[型体编号] as C0,a.[ID] as C1 from [main].[项目档案主表] as a  Where a.[项目编号] = @p0  ORDER BY a.[ID] ASC"
SQLite error (261): database is locked in "RAGMA journal_mode = WALRAGMA legacy_alter_table = true"
SQLite error (261): database is locked in "select a.[用户名] as C0 from [main].[用户信息视图] as a  Where a.[全名] = @p0  ORDER BY a.[用户名] ASC"
SQLite error (261): database is locked in "select a.[用户名] as C0 from [main].[用户信息视图] as a  Where a.[用户名] = @p0  ORDER BY a.[用户名] ASC"
SQLite error (261): database is locked in "select a.[用户名] as C0 from [main].[用户信息视图] as a  Where a.[全名] = @p0  ORDER BY a.[用户名] ASC"
SQLite error (261): database is locked in "select a.[ID] as C0 from [main].[任务接收与分派主表] as a  Where a.[ID] = @p0  ORDER BY a.[ID] ASC limit 1"
SQLite error (261): database is locked in "select a.[用户名] as C0 from [main].[用户信息视图] as a  Where a.[全名]  is null   ORDER BY a.[用户名] ASC"
SQLite error (261): database is locked in "select a.[用户名] as C0 from [main].[用户信息视图] as a  Where a.[用户名] = @p0  ORDER BY a.[用户名] ASC"
SQLite error (261): database is locked in "select a.[用户名] as C0 from [main].[用户信息视图] as a  Where a.[用户名] = @p0  ORDER BY a.[用户名] ASC"
Tid:64 2022-07-29 08:34:02: Set ServerInfo to NUll
Tid:60 2022-07-29 08:34:03: InitialServerInfos
Tid:60 2022-07-29 08:34:03: infoStr.length:122406
Tid:60 2022-07-29 08:34:03: Init ServerInfo
Tid:63 2022-07-29 08:34:04: InitialPageAuthorizeInfos
Tid:65 2022-07-29 08:34:09: Begin EnsureHiddenUserInfoTable
Tid:65 2022-07-29 08:34:09: End EnsureHiddenUserInfoTable
SQLite error (261): database is locked in "select a.[用户名] as C0 from [main].[用户信息视图] as a  Where a.[用户名]  is null   ORDER BY a.[用户名] ASC"
SQLite error (261): database is locked in "RAGMA journal_mode = WALRAGMA legacy_alter_table = true"
SQLite error (261): database is locked in "select a.[用户名] as C0 from [main].[用户信息视图] as a  Where a.[全名] = @p0  ORDER BY a.[用户名] ASC"
SQLite error (261): database is locked in "select a.[用户名] as C0 from [main].[用户信息视图] as a  Where a.[用户名] = @p0  ORDER BY a.[用户名] ASC"
SQLite error (261): database is locked in "select a.[用户名] as C0 from [main].[用户信息视图] as a  Where a.[用户名] = @p0  ORDER BY a.[用户名] ASC"
Tid:89 2022-07-29 08:48:29: Set ServerInfo to NUll
Tid:89 2022-07-29 08:48:29: InitialServerInfos
Tid:89 2022-07-29 08:48:29: infoStr.length:122431
Tid:89 2022-07-29 08:48:29: Init ServerInfo
Tid:89 2022-07-29 08:48:31: InitialPageAuthorizeInfos
Tid:94 2022-07-29 08:48:35: Begin EnsureHiddenUserInfoTable
Tid:94 2022-07-29 08:48:35: End EnsureHiddenUserInfoTable

您好，因为SQLite是一个文件数据库，所有的数据是以一个.sqlite文件保存的。当sqlite操作事务时，首先要锁定操作的数据，操作完成后再解锁。所以这些日志是SQLite记录锁定的日志，只要数据库正常使用没有报错，我们不需要关注。

若使用人数很多时会不会出问题， 或者说性能方面， 10几个在用， 有时页面卡，是不是这个的问题?

在操作设计器时，若在里面进行数据表迁移位置或者做一些操作常常会未响应，必须重起设计器，是不是锁定造成

使用人数多的时候，可以使用事务来保证数据不出错。10几个人一般不会有什么问题。

设计器会卡顿和数据表关系不大，一般是设计器渲染页面或读取数据，和安装设计器的电脑配置也有一定关系。