This came up in a discussion with a fellow cf developer: He said that, as a rule of thumb, an update query is slower than a insert or a select.
I said it was nominal, as 90% of the execution time goes to the query plan. Cfqueryparam's on your selects, inserts, and updates for the pk to be hit would end up with all pretty darn close. The only factor I could figure in was disk io to write on an update or insert, vs a select. I think, with good indexing, the where clauses used in a select, insert, or update should make all three about the same for execution time/performance. On a side note, I should get out more... :D ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
