then... its one of those things you have to decide on the move... if there is no real degredation then stick with a loop.. all things being equal, the SQL Server and the CF Server should be 100% optimised to handle load...
:-p -----Original Message----- From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl] Sent: 04 November 2002 13:42 To: CF-Talk Subject: Re: HELP!! sql wierdness ERROR message Robertson-Ravo, Neil (REC) wrote: > I would say that you would not find that much difference in peformace > on basic Select, Insert, Update or Deletes (the standard CF/SQL > Combos) but for more complex Joins etc you may find certain > degredation in peformance...... Exactly. However, we are talking about small inserts: <quote> if you want to do 50 small inserts in a row </quote> <001b01c283ff$98e6d900$c32f20d4@fizzypop> Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
