问题描述
我正在开发一个需要数据库的singler用户应用程序。大多数表将有一个合理的数据量,但有一些可能增长到几百万行。我的查询都不会返回大的结果集。
I'm developing a singler user application that needs a database. Most tables will have a reasonable amount of data, but there are a few that may grow to a few millions of rows. None of my queries will return a large result set.
任何人都知道HSQLDB是否可以处理这么多行?
Anyone know if HSQLDB can handle such a large number of rows?
推荐答案
HSQLDB可以处理数百万行。您可以尝试一些可以创建大型数据库的测试类。例如:
HSQLDB can handle millions of rows. You can try some of the test classes which can create large databases. For example:
或这里:
检查TestCacheSize和TestStressInsert类。
Check the TestCacheSize and TestStressInsert classess.
您应该使用内置备份功能并定期备份数据库。
You should use the built-in backup capability and regularly backup the database.
这篇关于HSQLDB能处理几百万行吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!