You bet, no disagreement on the other issues. I personally feel the human performance factor is the most important when dealing with applications. A few extra manhours on a project and a new faster server could have been purchased. Yeh, it could be argued that is not a good position and I would certainly agree. But economics are what they are. Half a dozen DB transactions a second VS 2 transactions a second is not a make or break as long as the machine can handle the load. If it can't, make the machine bigger as that is cheaper than making changes to an existing application.
CPU is not an issue as much as I/O activity. A 4 CPU box with 2 gig of memory and 10,000 RPM striped and RAID SCSI drives can move a lot of traffic. A large part of the DB fits in memory, especially the indexes. Network activity is not a real issue as 1 gig Ethernet can slam a whole lot of traffic. If that gets slow move up to fiber. One item that was not mentioned is application portability. If SP's are used then porting to another DB is a major effort. Using inline SQL, and sticking to the basics, and the application can run on just about any DB without change. And having been through three DB conversions it has proven the difficulties that can arise because of SP's and differences between DB's. While were on the subject indexes are really vital. A careful study of what columns are being used in where clauses, and indexing those columns, makes a dramatic difference in query time. Some say you can have too many indexes (especially if you do a lot of inserts and updates to index fields), some say not enough. As for me, I use what I need. The only constant is change. Ray Thompson Tau Beta Pi (www.tbp.org) The Engineering Honor Society 865-546-4578 -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, August 15, 2005 9:37 AM To: SQL Subject: RE: Using IN clause with a stored procedure You could do it that way yeah...(and I like the way you chose the 'correct' method for getting the ID) - it is personal preference but the other pointers remain. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:2365 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=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
