RE: OT - sql silly question

2003-01-29 Thread Craig Dudley
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

OT - sql silly question

2003-01-28 Thread Matthew P. Smith
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 wo