C# Database question Update

Question

0.00/5 (No votes)

See more:

Hi Everyone, I am a CS student who is going into their sophomore year and I am currently working in an internship. The person looking over me has told me he will be busy and I should use this website for help. Last week I have asked many questions regarding this project. Special thanks to TRK3 and dasblinkenlight for the incredible amount of help they have given me.

Here is a image of how the web service will be used. Link[^]
Sorry for the terrible drawing. But pretty much there are two different types of applications using a library that calls a the web service that is on a server. The web service is going to be used dynamically (i think that is how you say it?). The web service is going to talk to the data which is stored on the server. There are going to be millions of inserts and read/delete(at the same time) methods being called. Also I need to make this fast.

My question is, how should I keep my data? I was thinking of using an in-memory database like mySQL. Any thoughts on this? Context.Cache seems interesting.

Posted 11-Jul-11 6:50am

Member 8015046

Updated 11-Jul-11 10:17am

v2

Add a Solution

2 solutions

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)

Abhinav S · Answer 1 · 2011-07-11T06:53:00

Solution 1

IMO, yes using SQLite or even MySql is probably the best way to go.

Posted 11-Jul-11 6:53am

Abhinav S

wizardzz · Answer 2 · 2011-07-11T10:30:00

What data are you storing and what is the recover plan for this data? In my industry, we can't use an in-memory database for some things. Regulators don't like it.

I think you have posted a few times regarding Cache vs SQL. It seems like you just want to learn about Context.Cache. Why don't you try researching it on your own, or give CP members a chance to answer your original questions before posting again.