<div>
Thanks for the sugestion... in right direction.<br />
The complete solution to this issue is very wide, I think it can't be descrided here. It would be more better if you can provide me more links.<br />

</div>


Thanks for the sugestion... in right direction.
The complete solution to this issue is very wide, I think it can't be descrided here. It would be more better if you can provide me more links.


<div>
<div class="content wysiwyg-content">
Please provide solution for following issues for a web based application in ASP.NET 3.5:<br />
<br />
There is requirement for approx 10 to 20 million records entry in the database daily, or we can say that there would be around entry of 10 lakh records per table on daily basis. What would be the best Database Design, Model &amp;&nbsp;Architecture in MySQL database. Need proper optimization for quick retrieval, insertion, updates &amp;&nbsp;deletion. Also provide the hardware detail that would required to handle such a large database in long term.
</div>
</div>


Please provide solution for following issues for a web based application in ASP.NET 3.5:

There is requirement for approx 10 to 20 million records entry in the database daily, or we can say that there would be around entry of 10 lakh records per table on daily basis. What would be the best Database Design, Model & Architecture in MySQL database. Need proper optimization for quick retrieval, insertion, updates & deletion. Also provide the hardware detail that would required to handle such a large database in long term.

Large number of storage / insertion of records in MySQL - Part 1

Project management is the discipline of carefully projecting or planning, organizing, motivating and controlling resources to achieve specific goals and meet specific success criteria. A project is a temporary endeavor designed to produce a unique product, service or result with a defined beginning and end (usually time-constrained, and often constrained by funding or deliverables) undertaken to meet unique goals and objectives, typically to bring about beneficial change or added value.

Project Management

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Programming theory deals with the design, implementation, analysis, characterization, and classification of programming languages and their individual features, along with introductory programming concepts like program structure, variable declaration and conditional and looping constructs. Sub-disciplines include the formal semantics of programming languages, type theory, program analysis and transformation, comparative programming language analysis, metaprogramming, domain-specific languages, compiler construction and run-time systems.