> >Scope all the variables that you can.
> So what does this mean?
>
> Call all variables session.variable1
> instead of variable1 ? (For non-scoped
> vars).
It's more than just session variables - scope ALL variables.
This means if you're checking form info, then use form
Within a CFLoop or CFOutput, use the name of the query
Anything from the URL should be called with URL
etc. etc.
Also;
Ensure that the output to the browser is as clean as possible (with as
little white-space) using EnableCFOutputOnly rather than the automatic one -
it runs faster
When using queries, name the fields, don't use "select *" it's a lot slower
Avoid using CFUpdate and CFInsert - it's faster to use a CFQuery
Use CFSwitch where you can, rather than CFIF
Try to avoid IIF() where possible, it's 2-3 times slower than a CFIF
When setting loads of variables, use CFScript rather than CFSet
Clean your SQL queries to run as fast as possible - fat SQL is a lot slower
Then again, used Stored Procedures as much as possible
Erm, probably more, but I can't think of them now...
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
