单个 SQLite 数据库的多个文件 [英] Multiple files for a single SQLite database

问题描述

Afaik，SQLite 将单个数据库存储在单个文件中.由于这会降低处理大型数据库时的性能，是否可以明确告诉 SQLite 不要将整个数据库存储在单个文件中，而是将不同的表存储在不同的文件中?

Afaik, SQLite stores a single database in a single file. Since this would decrease the performance when working with large databases, is it possible to explicitly tell SQLite not to store the whole DB in a single file and store different tables in different files instead?

推荐答案

如果您不需要这些表之间的连接，您可以手动拆分 DB 并说明哪些表在哪个 DB (=file) 中.

If you don't need a join between these tables you can manually split the DB and say which tables are in which DB (=file).

我不认为让 SQLite 将您的数据库拆分为多个文件是可能的，因为您通过告诉文件名连接到数据库.

I don't think that it's possible to let SQLite split your DB in multiple files, because you connect to a DB by telling the filename.

这篇关于单个 SQLite 数据库的多个文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！