On 8/6/01, Evan Lavidor penned:
>Partly out of curiousity and partly out of need, I'm wondering whether
>anyone has any "ammunition" for discussions about best practices. For
>example, things like:
No ammunition, but from my experiencing and testing.
>1. lock shared variables
Of course
>2. prefix variables with a scope
Sometimes easier not to.
>3. select only columns you need instead of select *
Only if you only need a couple of fields. My experience shows that
using * when selecting all or most of the fields in a table,
especially if there are alot of them, is MUCH faster. I now try it
both ways and go with the fastest.
>4. cfscript is faster than multiple <cfset> statements when there's more
>than 3
Again, after reading this in CFDJ, I tried a test. Setting 100
variables using cfset and the same 100 variables inside of cfscript
both take the same amount of time, within a few milliseconds.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
