Choose the best DBMS for desktop application

Question

0.00/5 (No votes)

See more:

Hi everyone, unfortunately I don't know anything about databases, but I'm writing an application on a desktop computer (just one computer will access db, its not on a server) and it will be using a big amount of data (at least 10 million records, each record 1KB).
I think access database cant handle this amount of data fast enough, so I wanna know which DBMS is better for this situation and what is the requirement for the application to run on the destination computer.

* the program is written in c# and I will access the database directly with SQL commands, not linq or other things.

Thanks in advance ;)

Posted 19-Oct-11 10:56am

Amir Hossein Farhangi

Add a Solution

Comments

aidin Tajadod 19-Oct-11 18:39pm

take a look at sqlite at http://www.sqlite.org/

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Espen Harlinn · Accepted Answer · 2011-10-19T12:51:00

Solution 1

Not many "lightweight" databases handles that number of records well.

In your case I'd go for MS Sql Server 2008 R2, and work directly with SqlCommand and SqlDataReader. I've used that for solutions requiring > 100 million records, and if you are careful it performs very well.

Best regards
Espen Harlinn

Posted 19-Oct-11 12:51pm

Espen Harlinn

Comments

Simon Bang Terkildsen 19-Oct-11 19:28pm

Sql Server 2008 or Oracle would be my choice, depending on who my customers are.

Espen Harlinn 20-Oct-11 4:46am

Thanks Simon - yes oracle is also an excellent choice :)

Amir Hossein Farhangi 20-Oct-11 15:20pm

Thanks both of you, I just wanted to avoid sql server but it seems there is no other choice.
And dear Simon, could you please tell me which oracle database is better for this situation? I think there are plenty of them.

Espen Harlinn 20-Oct-11 19:16pm

I think you will find that the standard edition of oracle RDBMS will do nicely, but keep in mind that when you are working with .Net it's easier to get help with SQL server. I've used Oracle RDBMS for more than 10 years and it has proven to be a very stable product, while SQL server has given me a lot of grief until the 2008 edition - which has shown itself to be remarkably stable compared to earlier editions.

Amir Hossein Farhangi 22-Oct-11 13:29pm

So I will use SQL server 2008.
Thank you very much dear Espen, you helped me a lot.