| DB Server Configuration [message #631197] |
Sat, 10 January 2015 04:28  |
 |
ninan
Messages: 163
Registered: June 2011
Location: Noida
|
Senior Member |
|
|
Hi,
Building a new application which is expected to have 30 million users.
and each user will make average of 2 searches per visit.
It should support that 20% of the visits will add items to the shopping cart.
And it should support for 15% of the visits will be checked out.
The application should be able to support 1.5 million orders per month.
Of which 10% of the submitted orders are modified.
It should support the average size of 5 item lines per order
Requirement is to store all customer order history for 2 years before purging.
The number of concurrent visits on a busy hour can be 15000 per hour, during high peak shopping seasons.
The user experience is expected such that, item search and display TO sales checkout should not take more than 3 seconds for a user.
What could be a ideal Database server configuration (Oracle 11g R2) required with respect to the Size, Memory and other aspects of the Database, considering all these scenarios, Is a DB of Terabyte size required to meet this.
Thanks,
ninan.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
