> Anybody noticed any slow down when using CFUPDATE rather than CFQUERY. We
> appear to be getting major delays of around 16 seconds on an CFUPDATE.
>
> We are using Oracle Native drivers.
CFUpdate and CFInsert are naturally slower than a CFQuery as it has to work
out the field types, identity field et.al.
If you can, you should always use CFQuery rather than CFUpdate or CFInsert
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
