Jonathan Lewis wrote:
> "DA Morgan" <damorgan_at_psoug.org> wrote in message
> news:1128879531.172572_at_yasure...
>
>><RANT>
>>
>>How many times can a row be inserted? Once!
>>How many times can a row be deleted? Once!
>>How many times is a row, realistically, updated? Once? Twice?
>>How many times is a row queried? Over and over and over again!
>>
>>Optimize for the report writers. Optimize for the people that are
>>hitting the same row over and over again for today's totals, the
>>week's totals, the month's totals, this quarter vs. last quarter,
>>this year vs. last year.
>>
>></RANT>
>>
>
> I think this is too important a point to be surrounded
> by <RANT></RANT> delimiters, as they make it
> sound like a tub-thumping opinion rather than part
> of a necessary rational design approach.
>
> I agree whole-heartedly with the sentiment - and it applies
> across the board.
> How much resource does operation X take ?
> How many times do I do it
> How much resource does operation Y take ?
> How many times do I do it
> Which one can take an extra overhead, which one can
> gain from the use of a feature. What's the correct trade.
Thank you.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Oct 17 2005 - 19:50:20 CDT
