|
|
Posted by RickW on 03/07/06 22:00
Happy to report, Techniques 1 & 2 in place.
Technique 3: I don't remember having any case statements in order by.
I would check, but I suppose it doesn't matter anyway, since I'm
removing all the order by clauses from the views except where merited by
proper use of Top. In any event, it's a clever tip. Hope I remember it
when the occasion arises.
Technique 4: Very handy, especially as I'm new in .NET and this is a
clearly useful tip. I probably would have by habit put the Order By in
the SQL that goes up to the server. I can imagine that if a have a very
large return (rare in our case), a hefty server compared to the load,
and rather wimpy client machines, I might send the Order By up the line
to let the server do it, but staying mindful of your tip I have the
option to do it only when merited.
Thanks so much for the link.
Science is organized common sense where many a beautiful theory was
killed by an ugly fact. -- Thomas Huxley
*** Sent via Developersdex http://www.developersdex.com ***
Navigation:
[Reply to this message]
|