Click here to Skip to main content
15,920,217 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
AnswerRe: Documenting Design Pin
Pete O'Hanlon13-Jan-09 22:39
mvePete O'Hanlon13-Jan-09 22:39 
AnswerRe: Documenting Design Pin
CodingYoshi16-Jan-09 3:31
CodingYoshi16-Jan-09 3:31 
GeneralRe: Documenting Design Pin
K. Shaffer17-Jan-09 6:53
K. Shaffer17-Jan-09 6:53 
GeneralRe: Documenting Design Pin
Karthik Jegadeesan19-Jan-09 21:44
professionalKarthik Jegadeesan19-Jan-09 21:44 
GeneralRe: Documenting Design Pin
K. Shaffer22-Jan-09 12:50
K. Shaffer22-Jan-09 12:50 
GeneralRe: Documenting Design Pin
K. Shaffer22-Jan-09 13:00
K. Shaffer22-Jan-09 13:00 
QuestionDatabase Queries Pin
CodingYoshi6-Jan-09 17:20
CodingYoshi6-Jan-09 17:20 
AnswerRe: Database Queries Pin
Wendelius7-Jan-09 2:29
mentorWendelius7-Jan-09 2:29 
Some opinions:

I think you should use stored procedures or views (which ever you prefer) to get the data. You can combine several needs to a single procedure, but I would think the procedure output as an interface (technically not the same as in .Net but the idea). If there are several needs which are almost identical and they don't change the logic of the output and there's no performance penalty, I would combine those.

About the static class. This is basically caching and it's a good way to ensure performance. However you must consider when to refresh the data in the static class. When and how are the modifications fetched to the class. You might want to use SqlDependency[^] if it's SQL Server you're using.

One thing you didn't mention at all was security. I don't know if it's an issue but is it ok that all the data can be used by clients. If not, that consideration should be part of the process when you think what procedures you'll create.

The need to optimize rises from a bad design.My articles[^]

GeneralRe: Database Queries Pin
CodingYoshi7-Jan-09 8:49
CodingYoshi7-Jan-09 8:49 
GeneralRe: Database Queries Pin
Wendelius7-Jan-09 9:16
mentorWendelius7-Jan-09 9:16 
GeneralRe: Database Queries Pin
Jon Rista7-Jan-09 12:20
Jon Rista7-Jan-09 12:20 
GeneralRe: Database Queries Pin
Wendelius8-Jan-09 2:47
mentorWendelius8-Jan-09 2:47 
GeneralRe: Database Queries [modified] Pin
Jon Rista8-Jan-09 4:55
Jon Rista8-Jan-09 4:55 
GeneralRe: Database Queries Pin
Wendelius8-Jan-09 5:25
mentorWendelius8-Jan-09 5:25 
GeneralRe: Database Queries Pin
Jon Rista8-Jan-09 10:56
Jon Rista8-Jan-09 10:56 
GeneralRe: Database Queries Pin
Mark Churchill7-Jan-09 13:53
Mark Churchill7-Jan-09 13:53 
QuestionSoftware development Pin
systemexpertise1-Jan-09 18:26
systemexpertise1-Jan-09 18:26 
AnswerRe: Software development Pin
Cosmic Egg10-Jan-09 3:29
Cosmic Egg10-Jan-09 3:29 
QuestionStylesheet in VS2008 Pin
sarang_k30-Dec-08 19:01
sarang_k30-Dec-08 19:01 
AnswerRe: Stylesheet in VS2008 Pin
CodingYoshi4-Jan-09 15:45
CodingYoshi4-Jan-09 15:45 
QuestionException Hierarchy Pin
CodingYoshi29-Dec-08 11:27
CodingYoshi29-Dec-08 11:27 
GeneralRe: Exception Hierarchy Pin
Luc Pattyn29-Dec-08 15:12
sitebuilderLuc Pattyn29-Dec-08 15:12 
GeneralRe: Exception Hierarchy Pin
CodingYoshi30-Dec-08 3:18
CodingYoshi30-Dec-08 3:18 
AnswerRe: Exception Hierarchy Pin
Jon Rista6-Jan-09 8:48
Jon Rista6-Jan-09 8:48 
GeneralRe: Exception Hierarchy Pin
Leftyfarrell6-Jan-09 13:29
Leftyfarrell6-Jan-09 13:29 

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.