Click here to Skip to main content
15,904,817 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
AnswerRe: MVVM architecture for a Hardware based application Pin
jschell13-Jun-13 8:53
jschell13-Jun-13 8:53 
AnswerRe: MVVM architecture for a Hardware based application Pin
dusty_dex13-Jun-13 8:55
dusty_dex13-Jun-13 8:55 
AnswerRe: MVVM architecture for a Hardware based application Pin
Jonathan Davies14-Jun-13 3:00
Jonathan Davies14-Jun-13 3:00 
GeneralRe: MVVM architecture for a Hardware based application Pin
Praveen Raghuvanshi17-Jun-13 1:28
professionalPraveen Raghuvanshi17-Jun-13 1:28 
QuestionSoftware Design Books Pin
msr_codeproject13-Jun-13 2:43
msr_codeproject13-Jun-13 2:43 
AnswerRe: Software Design Books Pin
Amarnath S13-Jun-13 17:38
professionalAmarnath S13-Jun-13 17:38 
GeneralRe: Software Design Books Pin
msr_codeproject13-Jun-13 23:47
msr_codeproject13-Jun-13 23:47 
QuestionQUERY FOR ALL vs QUERY FOR EACH Pin
Paulo S X Soares5-Jun-13 4:13
Paulo S X Soares5-Jun-13 4:13 
Right now I'm facing an issue I had faced much times, but now I decided go deep in it. (for our purpose, let's consider PHP with MySQL)
What's the most convenient method to get a collection of records from a database?

A) Query a collection of records and populate an array of objects through a loop, or

B) Execute a loop on an array where each object is initialized through his own method (with, of course, one query for each record)

A pros: less connections or data traffic.
A cons: duplicated code to retrieve same data, increasing maintenance.

B pros: a standar method to get data, minimizing maintenance.
B cons: most connections or data traffic.

I known that each option can be applied for each context, but I bring this question to a context where we have no idea of the future implications.

Please, give your opinion or suggestions, or tell me where I can find a publication specifically about this issue.

Thanks
AnswerRe: QUERY FOR ALL vs QUERY FOR EACH Pin
Bernhard Hiller5-Jun-13 21:16
Bernhard Hiller5-Jun-13 21:16 
GeneralRe: QUERY FOR ALL vs QUERY FOR EACH Pin
Paulo S X Soares6-Jun-13 2:50
Paulo S X Soares6-Jun-13 2:50 
GeneralRe: QUERY FOR ALL vs QUERY FOR EACH Pin
Eddy Vluggen6-Jun-13 2:54
professionalEddy Vluggen6-Jun-13 2:54 
GeneralRe: QUERY FOR ALL vs QUERY FOR EACH Pin
Paulo S X Soares6-Jun-13 3:06
Paulo S X Soares6-Jun-13 3:06 
AnswerRe: QUERY FOR ALL vs QUERY FOR EACH Pin
Abhinav S5-Jun-13 22:17
Abhinav S5-Jun-13 22:17 
GeneralRe: QUERY FOR ALL vs QUERY FOR EACH Pin
Paulo S X Soares6-Jun-13 2:58
Paulo S X Soares6-Jun-13 2:58 
AnswerRe: QUERY FOR ALL vs QUERY FOR EACH Pin
jschell6-Jun-13 10:15
jschell6-Jun-13 10:15 
GeneralRe: QUERY FOR ALL vs QUERY FOR EACH Pin
Paulo S X Soares7-Jun-13 5:22
Paulo S X Soares7-Jun-13 5:22 
GeneralRe: QUERY FOR ALL vs QUERY FOR EACH Pin
jschell10-Jun-13 9:02
jschell10-Jun-13 9:02 
QuestionHelp on designing DB/ Web Service Pin
DavJes4-Jun-13 7:49
DavJes4-Jun-13 7:49 
AnswerRe: Help on designing DB/ Web Service Pin
jschell4-Jun-13 8:54
jschell4-Jun-13 8:54 
AnswerRe: Help on designing DB/ Web Service Pin
Eddy Vluggen4-Jun-13 8:55
professionalEddy Vluggen4-Jun-13 8:55 
GeneralRe: Help on designing DB/ Web Service Pin
DavJes9-Jun-13 7:03
DavJes9-Jun-13 7:03 
GeneralRe: Help on designing DB/ Web Service Pin
Eddy Vluggen10-Jun-13 3:26
professionalEddy Vluggen10-Jun-13 3:26 
QuestionTransactional MSMQ & firewall Pin
John Padgett27-May-13 22:35
John Padgett27-May-13 22:35 
AnswerRe: Transactional MSMQ & firewall Pin
jschell28-May-13 9:31
jschell28-May-13 9:31 
QuestionSOA and exposing a program from the 80s Pin
darklies17-May-13 19:37
darklies17-May-13 19:37 

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.