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
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