如何合并许多SQLite数据库？ [英] How can I merge many SQLite databases?

问题描述

如果我有大量的SQLite数据库，所有具有相同的模式，什么是最好的方式将它们合并在一起，以便对所有数据库执行查询？

If I have a large number of SQLite databases, all with the same schema, what is the best way to merge them together in order to perform a query on all databases?

我知道可以使用 ATTACH 执行此操作，但它具有32位和64位数据库的限制，具体取决于内存系统。

I know it is possible to use ATTACH to do this but it has a limit of 32 and 64 databases depending on the memory system on the machine.

推荐答案

这将按需完成，每天可能多次。我会看到它的工作方式如在 http://sqlite.1065341.n5.nabble.com/Attempting-to-merge-large-databases-td39548.html 其中数据库合并到一个大型数据库中，执行查询，然后删除大型数据库。

This would be done on demand, possible several times a day. The way I would see it working is as in http://sqlite.1065341.n5.nabble.com/Attempting-to-merge-large-databases-td39548.html where the databases are merged into a large DB, the query performed and then the large database deleted.

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