php – 从PDO增加SQLite中附加数据库的限制

我正在开发一个项目,每个表使用一个数据库文件应该会受益匪浅,主要是因为我正在尝试 avoid having the database grow too large,但也因为 file locking issues.

我想使用ATTACH statement在我的所有表中都有一个“虚拟”数据库,但我发现虽然附加数据库的上限是62(这对我来说完全可以接受),但附加数据库的默认限制是事实上,从SQLite limits page开始：

Maximum Number Of Attached Databases

The ATTACH statement is an SQLite extension that allows two or more
databases to be associated to the same database connection and to
operate as if they were a single database. The number of
simultaneously attached databases is limited to SQLITE_MAX_ATTACHED
which is set to 10 by default. The code generator in SQLite uses
bitmaps to keep track of attached databases. That means that the
number of attached databases cannot be increased above 62.

由于我需要支持10个以上的表,我的问题是,如何将PHP的SQLITE_MAX_ATTACHED变量设置为更高的值(使用带有SQLite 3的PDO)？

您必须重新编译PHP才能更改它们.

（编辑：安卓应用网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!