You might squeak out a bit of performance by making a stored procedure out of
it and using an "optimistic update" strategy... Just do the update and if the
record count is zero then do an insert. This will completely remove the select.
(I guess you don't need a sp for this.)
Mark
-----Original Message-----
From: Jim Davis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 28, 2004 11:46 AM
To: CF-Talk
Subject: RE: Dumb Question About CFPARAM
Yup - of course CFQUERYPARAM is what I meant. The mind does strange thigs
at three AM. ;^)
Thanks, all - it does seem to work just fine. Unfortunately it doesn't
offer as much of a speed boost as I was hoping, but I'll take what I can
get.
Jim Davis
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188870
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
