We need to figure out how many operations per second we can expect. We can estimate this by using the following steps:
- Increment the Count column in our hardware spreadsheet for one or more of the following, and round up:
- For 3.5" hard drives, divide by 200
- For 2.5" hard drives, divide by 150
- For SSD hard drives, divide by 50,000, then add two
- Multiply these numbers together, and double the result. Then multiply the total by eight.
- Count the amount of tables used in those queries. If this is unavailable, use three.
- Obtain the average number of queries per page. If this is unavailable, use 10.
- Collect the amount of simultaneous database connections. Start with the expected user count, and divide by 50.
- Add 10 percent to ...