SQLite和DISQLite如何比较大型简单数据库？ [英] How Do SQLite and DISQLite Compare for a Large Simple Database?

问题描述

SQLite 和 DISQLite ，为什么要选择一个？

我的上下文是我正在处理一个大型数据库（可能高达10 GB），其关键部分是在一个非常简单的表中，单个索引字段和一个文本字段大小可达几KB 。我的开发工具是Delphi 2009，数据库将嵌入我的.exe。

我的主要标准是速度。这将是一个典型的Windows计算机上运行的软件应用程序，比如Windows 7和4 GB的RAM。

如果你想建议另一个数据库工具，请告诉我为什么会比这两个应用程序更好，特别是在速度方面。

解决方案

AFAIR，DISQLite使用obj Sqlite的文件，并使用Delphi编译它们，并产生比原始文件更多的功能，并使用相同的sqlite数据库格式，因此您可以通过支持Sqlite驱动程序的其他语言读取DISQLite数据库文件。

另外还有一个功能与DISQLite您不必分发Sqlite DLL。

DISQLite支持数据库大小高达2TB ，所以它可以处理你的需求，没有问题。

另一个选项，我会考虑的是FireBird嵌入式版本，如果你想扩大它，你可以更改为完整FireBird服务器没有太多的努力/ p>

但我认为Sqlite& DISQLite会比Firebird效果更好。

我使用 Audcom Sqlite组件访问Sqlite数据库，您可以使用Sqlite objs文件进行编译，因此您将不会部署sqlite dll。

What are the differences between SQLite and DISQLite and why would I want to pick one over the other?

My context is that I am dealing with a large database (could be up to 10 GB), the critical part of which is in one very simple table with a single indexed field and one text field up to a few KB in size. My development tool is Delphi 2009 and the database will be embedded in my .exe.

My main criteria is speed. This would be for a software application running on a typical Windows computer, say with Windows 7 and 4 GB of RAM.

If you want to suggest another database tool, please tell me why it would be better than these two for my application, especially on the speed frontier.

解决方案

AFAIR, DISQLite uses the obj files of Sqlite, and compile them with Delphi and produce more features than the original one, and using the same sqlite DB format, hence you can read the DISQLite database file by it by other languages that has support for Sqlite drivers.

Also one more feature with DISQLite you don't have to distribute the Sqlite DLL.

DISQLite support database size up to 2TB, so it could handle your requires without problems.

Another options I would consider is FireBird embedded version,and if you would like to scale it more, you can change to full FireBird server without much effort.

But I think both Sqlite & DISQLite will perform better than Firebird.

I use Audcom Sqlite components to access Sqlite databases, and you can compile it with Sqlite objs file so you will not have deploy sqlite dll.

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