What is the most efficient way to update a server database?

Question

I have a database in a server. Around 100 client PCs are connected to it from different locations. Now these clients are inserting data in this database within an interval of 10 seconds. Now what is the most efficient way to do this?

1. I can open connection from every client pc to the server database. OR
2. I can have a web service in the server and the clients will call the web service to do the insertion. OR no more ideas :(

Please someone tell me what is the efficient way to do this. I'm using SQL Server 2008 and Windows Server 2008.

Answer 1

Use table locking if you are worried that people might overwrite each other's idata