用于大型数据集的 SQLite? [英] SQLite for large data sets?

问题描述

我有一个相当大的数据集，并希望将其存储在文件中而不是 RDBMS 中.

I have a reasonably large data set and would like to store it in a file rather than a RDBMS.

数据集中的主表只有超过 100 万行、30 列和大约 600Mb 的 CSV 大小.

The main table in the data set is just over 1M rows, 30 columns and about 600Mb in size as a CSV.

我正在考虑使用 SQLite.对于这种规模的数据集，SQLite 值得研究吗?

I'm considering SQLite. Is SQLite worth investigating for data sets of this size?

推荐答案

SQLite 会很好地处理那个文件；确保在事务中导入记录，以便在导入所有内容之前不会花费大量时间创建索引.

SQLite will handle that file just fine; make sure to import the records in a transaction so that it doesn't spend a lot of time creating indexes until everything is imported.

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