I agree with Phil too - let the DB do the work As far as connection pooling goes - I think there is a misunderstanding as to what it does. The most lengthy process (relatively) in going to a db and getting data is creating the connection itself. Connection pooling just holds on to connections for reuse - you still have to go back to the database and get the data and bring it back to the client via that connection.
-----Original Message----- From: Robertson-Ravo, Neil (REC) [mailto:Neil.Robertson-Ravo@;csd.reedexpo.com] Sent: 04 November 2002 13:25 To: CF-Talk Subject: RE: HELP!! sql wierdness ERROR message >> 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
