Fast data read / write methods embedded into VB .NET program

Question

Currently I have been working on a program that has grown much bigger than I originally thought. I save the data that it generates to text files and then read from those when the data is needed or upon launching the program.. This is quite slow of course once the data gets to a large size.

I know setting up a SQL server is a good, efficient way to store data usually but I want my application to be "self contained", meaning it doesn't need to be on a network to work (so that rules out SQL). I have read up a little bit on SQLLITE which seems better but still requires the user to install something, rather than just run my program so it isn't "self contained". I want to know if anyone else has found something that can be embedded into the solution? My idea is that all the data would still reside in a file that contains the database and is built upon build or some sort of events from the program.

I hope what I am asking makes sense. Basically I just want to avoid the user from having to install anything and if I copy my program and the "database files" to another computer, it will work without problems.

Dont rule out still more future like concurrent, networked users, web access. The nature of the data and expected use case should be more important than no-server. — Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp, Commented May 31, 2016 at 18:13
Due to the environment I work in I am unable to host an actual server due to security here at my work being why I want to keep it local to each user. — Eric F
– Eric F, Commented May 31, 2016 at 18:16
Use SqlLite users more than likely don't need to install anything... — Trevor
– Trevor, Commented May 31, 2016 at 18:17
@zaggler Can you transfer your data easily like I asked above? can the database be transferred just by copying a file over? I apologize but I haven't used SQLLITE before. — Eric F
– Eric F, Commented May 31, 2016 at 18:18
If you like to use MS Sql in general, you can also use Sql Compact. I think it is also stand alone, similar to SQLite. It supports Entity Framework as well. — Chris Dunaway
– Chris Dunaway, Commented Jun 1, 2016 at 15:16

Trevor · Accepted Answer · 2016-05-31 18:30:24Z

1

I have read up a little bit on SQLLITE which seems better but still requires the user to install something

User's typically do not need to install anything as it's a stand-alone...

SQLite features are robust and would suit saving and retrieving your data back. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.

To read more please see uses in which this explains more in detail.

answered May 31, 2016 at 18:30

Trevor

8,0156 gold badges35 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Fast data read / write methods embedded into VB .NET program

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related