如何在桌面应用程序中使用大型本地数据库文件 [英] How to use large local database files in desktop application

问题描述

我正在以C#.net win形式开发桌面应用程序.我必须读/写大文件(可能以GB为单位).哪个用户可以为其使用创建.

例如，用户想要创建一个大型的英语单词词典，然后在某个时候阅读它，或者在他的词典中搜索单词.并更新字典以更新某些文本或添加更多单词. (尽管它不是真实的实际示例，但在这里引用它只是为了使我的观点易于理解)

绝对普通的文本或xml文件格式不能处理如此大的数据.我目前正在考虑SQLite数据库，但是它也有一些局限性并且效率不够(或者可能是我没有以正确的方式使用它).现在，我需要帮助，我应该在应用程序中使用哪种数据技术选项来开发大型文件.

Hi,

I am developing a desktop application in C#.net win forms. I have to read/write large size of files(may be in GBs). which user can create for its usage.

For example, user want to create a large English words dictionary and then read it at some time, or searching for a word in his dictionary. and update the dictionary to update some text or add more words. (although its not real the practical example, but just quoted here to make my point understandable)

Definitely normal text or xml files format could not handle such big size of data. I am currently thinking about SQLite databases, but it also has some limitations and not efficient enough(or may be I am not using it in right way). Now I need help what data technology option should I use to develop in my application to work with large sized files.

推荐答案

为什么不使用sql server express作为本地数据库存储?
http://www.microsoft.com/sqlserver/en/us/editions/express.aspx [^ ]

祝你好运！

Why not use sql server express as local database storage?
http://www.microsoft.com/sqlserver/en/us/editions/express.aspx[^]

Good luck!

这篇关于如何在桌面应用程序中使用大型本地数据库文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！