Click here to Skip to main content
15,891,730 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
Questionapplication Integration Pin
kebedetesema19-Jul-09 23:17
kebedetesema19-Jul-09 23:17 
AnswerRe: application Integration Pin
David Skelly20-Jul-09 2:45
David Skelly20-Jul-09 2:45 
GeneralRe: application Integration Pin
kebedetesema20-Jul-09 4:08
kebedetesema20-Jul-09 4:08 
GeneralRe: application Integration Pin
David Skelly20-Jul-09 22:38
David Skelly20-Jul-09 22:38 
GeneralRe: application Integration Pin
kebedetesema21-Jul-09 21:43
kebedetesema21-Jul-09 21:43 
GeneralRe: application Integration Pin
Robin_Roy21-Jul-09 19:25
Robin_Roy21-Jul-09 19:25 
AnswerRe: application Integration Pin
Rozis20-Jul-09 11:04
Rozis20-Jul-09 11:04 
QuestionLarge number of storage / insertion of records in MySQL Pin
ajitsunny18-Jul-09 3:54
ajitsunny18-Jul-09 3:54 
Please suggest for following issues for a web based application in ASP.NET 3.5:
1.
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.

2.
There is a scenario of inventory management of advertisements on daily basis, if there are 100,000 locations and user booked these locations for 1 year then I need to insert/update 100,000 x 365 = 36500000 records/rows in the table to maintain daily inventory. Please suggest better solution & table structures.

[Database Design, Model & Architecture for Large number of storage / insertion of records in MySQL]
AnswerRe: Large number of storage / insertion of records in MySQL Pin
Eddy Vluggen18-Jul-09 9:42
professionalEddy Vluggen18-Jul-09 9:42 
AnswerRe: Large number of storage / insertion of records in MySQL Pin
Robin_Roy26-Jul-09 17:50
Robin_Roy26-Jul-09 17:50 
GeneralRe: Large number of storage / insertion of records in MySQL Pin
ajitsunny4-Aug-09 0:00
ajitsunny4-Aug-09 0:00 
QuestionHibernate-style coding? Pin
NandoMan16-Jul-09 21:17
NandoMan16-Jul-09 21:17 
AnswerRe: Hibernate-style coding? Pin
NandoMan16-Jul-09 21:46
NandoMan16-Jul-09 21:46 
AnswerRe: Hibernate-style coding? Pin
Curtis Schlak.17-Jul-09 15:24
Curtis Schlak.17-Jul-09 15:24 
GeneralRe: Hibernate-style coding? Pin
NandoMan19-Jul-09 7:03
NandoMan19-Jul-09 7:03 
GeneralRe: Hibernate-style coding? Pin
Curtis Schlak.21-Jul-09 16:17
Curtis Schlak.21-Jul-09 16:17 
QuestionCreating interface that can read network traffic Pin
that_dude_tj16-Jul-09 13:11
that_dude_tj16-Jul-09 13:11 
AnswerRe: Creating interface that can read network traffic Pin
CodingYoshi16-Jul-09 17:15
CodingYoshi16-Jul-09 17:15 
GeneralRe: Creating interface that can read network traffic Pin
that_dude_tj17-Jul-09 14:48
that_dude_tj17-Jul-09 14:48 
QuestionConsultant/Principal/Senior Software Engineer Pin
leowangrenbenmg15-Jul-09 23:24
leowangrenbenmg15-Jul-09 23:24 
AnswerRe: Consultant/Principal/Senior Software Engineer Pin
Pete O'Hanlon15-Jul-09 23:34
mvePete O'Hanlon15-Jul-09 23:34 
GeneralRe: Consultant/Principal/Senior Software Engineer Pin
Paul Conrad25-Jul-09 19:26
professionalPaul Conrad25-Jul-09 19:26 
GeneralRe: Consultant/Principal/Senior Software Engineer Pin
Pete O'Hanlon29-Jul-09 9:11
mvePete O'Hanlon29-Jul-09 9:11 
GeneralRe: Consultant/Principal/Senior Software Engineer Pin
Paul Conrad29-Jul-09 12:39
professionalPaul Conrad29-Jul-09 12:39 
AnswerRe: Consultant/Principal/Senior Software Engineer Pin
Eddy Vluggen16-Jul-09 2:27
professionalEddy Vluggen16-Jul-09 2:27 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.