Hmm, if your table has good indexes, then updates and inserts will be slower than selects, after all that's what indexes are for, speeding up selects.
-----Original Message----- From: Matthew P. Smith [mailto:[EMAIL PROTECTED]] Sent: 29 January 2003 03:20 To: CF-Community Subject: OT - sql silly question 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
