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.