Well if you turn on full debugging then u can see the sql statements, you could also enable SQL profiling on the sql server to see what was going on if you really wanted to know. Yes it introspects the database to get the metadata it needs, I did do some performance testing once and did not find any significant performance issues.
Russ -----Original Message----- From: Rick Root [mailto:[email protected]] Sent: 23 September 2010 16:25 To: cf-talk Subject: Re: cfinsert/cfupdate How does Coldfusion manufacturer the queryparams? It must inspect the database to determine field types... I wonder if that's a performance hit... I just hate not knowing what the hell its doing. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337392 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

