Write to shared txt file or DB table from web service?

I am developing a web service that will be invo开发者_Go百科ked (using JSON) from client side each time the selection of a drop down changes. The goal is to register each "intermediate" change (on client side) using the "OnSelectedIndexChanged" event and before submitting the form to the Server.

Each new selected value will be written to a shared txt file calling a relative web method via Ajax/JSON.

Would it be better to write these changes to a txt file (having to implement a lock/unlock policy to assure exclusive access) or rather define a DB table and save the changes there?

Everyday the web app will have around 10 to 20 active users that might potentially changes the DropDownLists and usually the right value will be selected at first, hence generally no more than one "intermediate" entry would be registered.

Thanks.

---

Don't use the filesystem. It's slow. Use mongodb via a node.js webserver.

http://howtonode.org/express-mongodb

Good Luck!

---

This sounds exactly like what you would want to use a database for, since ACID is already implemented there.

If you want a real headache (and a programming challenge!) trying to debug overlapping writes, resource starvation and deadlocks, by all means, go with a shared text file!