[thelist] Tip - ColdFusion and Datasources

Ken Schaefer ken at adOpenStatic.com
Sun Aug 17 21:06:08 CDT 2003


----- Original Message ----- 
From: "Jeff Howden" <jeff at jeffhowden.com>
Subject: RE: [thelist] Tip - ColdFusion and Datasources


: > From: rudy
: >
: > > i will agree, however, that the sql3 syntax for doing
: > > multiple inserts is *very* cool, short, readable, etc.
: > > i just don't see it being an issue of improved
: > > performance.
: >
: > except if you cannot send more than one statement at
: > a time
:
: sure, but if you're using an rdbms that doesn't support
: multiple queries in a single connect, maybe it's time to upgrade
: to something alittle more robust for more important reasons
: than just the speed of inserts.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

What DBMS doesn't support executing more than one statement over an incoming
connection?

Surely, if the client app needs to disconnect after running each statement,
and reconnect to send the next statement, that's got to be about the worst
possible DBMS implementation in the known universe...

Cheers
Ken



More information about the thelist mailing list