1 million records from 1 million users at same time

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

, +

Hi All,

I am going to build one application using .net.
In this application I am using SQL SERVER. Application should give quick response when there are 1 million insert operations from 1 million users at same time.

Is there any way to make this operation faster in SQL SERVER?
Please suggest any good architecture.

Thanks

Posted 17-Sep-15 2:08am

Member 10010145

Add a Solution

Comments

F-ES Sitecore 17-Sep-15 8:44am

The fastest performing databases on the fastest servers costing millions of pounds would take 200,000 years to process this data. Good luck :)

Dave Kreskowiak 17-Sep-15 9:36am

You're definitely NOT going to get that kind of performance out of a single SQL server, no matter how powerful the hardware and how fast the network connection.

Look into SQL Server Farms and adjust the design of your application accordingly.

Philippe Mori 17-Sep-15 12:13pm

What does your recors contains? Do you really that much record? Is the record data large? Will you query that data for specific rows?

Maybe it is the wrong approach for that problem.

Do you add the row all at once ?

You can try to insert data for a single user and see the performance. If it take 1 hour for 1 user then it will take one millions hour for all users. Then say you are able to have 100 time that performance at a cost you can afford, then it would take 10000 hours.

In addition, you have to estimate database size. It would be very huge and you would need several terabytes of storage.

You also have to take into account the performance of using the data and how much developpers works on that application as you would need to do a lot of testing and optimisation even if you can somehow reduce the size of the problem.

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)

OriginalGriff · Answer 1 · 2015-09-17T02:31:00

Solution 1

You are going to need to set up (or rent access to) a Database Server Farm.[^]

Posted 17-Sep-15 2:31am

OriginalGriff