On Thu, Oct 9, 2014 at 12:30 PM, Les Mizzell wrote:
> Is there a better way to set up my two insert queries above so it's not
> making two calls for every single address?
Most databases will let you issue multiple SQL statements in a single
request/transaction. You just have to separate them with a semicolon.
I have done things before like this:
<cfquery>
<cfloop>
INSERT INTO table (...) VALUES(...);
</cfloop>
</cfquery>
Certain platforms may require you to turn on a switch in the JDBC
driver to allow this, but you can probably get your 10,000 queries
down to one single SQL call if you do it right.
-Cameron
...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359426
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
