How true. Back in my mainframe days in the 70's and 80's we would spend thousands of dollars in products and man-hours studying the performance of the system to get as much out of the system as possible. And it was worth it as the machines were very expensive. Today 5 man-hours (including overhead) more than pays for a complete new system. People time is very expensive, hardware is cheap. The human interface is the most important factor today.
I sometimes miss the old days until I remember the hours spent going over reams of performance reports just to determine that adding another spindle to the workspace drives would significantly improve performance. Ray Thompson Tau Beta Pi (www.tbp.org) The Engineering Honor Society 865-546-4578 -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 17, 2005 5:55 PM To: SQL Subject: Re: Using IN clause with a stored procedure Ray Thompson wrote: > Remember that a lot of the > conventional wisdom was developed on 200 MHZ machines. Had they had 200 MHz machines they wouldn't have studied optimization as much as they did :) For instance, Optimal Nesting for Computing N-relational Joins by Ibaraki and Kameda is from 1984 (and still a must-read) so I doubt it is even from the 2 MHz age. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2367 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
