>> A database is designed to perform SQL queries. Yes, true but I can see what Phil is saying; if you are constantly looping and reconnecting to the DB Server to perform what essentially could be completed with say an SP or a SQL Block then let the SQL Server perform what it is good at.... SQL.
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...... N -----Original Message----- From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl] Sent: 04 November 2002 13:20 To: CF-Talk Subject: Re: HELP!! sql wierdness ERROR message Stephen Moretti wrote: > >> sending those requests as separate CFQuery tags is pretty much insane > >>- building one big TSQL statement with one hit to the database server > >>is a much better solution > > > >Why would that be insane? > > > > Because that's 50 connect/deconnect to the database via your DB driver Connection pooling? > as opposed to one connect/disconnect and letting your DB do the job it > was designed to do. A database is designed to perform SQL queries. 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm