If you use <cfset> in the Application.cfm file, the <cfset> gets executed
every time a page is loaded, regardless if the variable already has its
value or not. If you use <cfparam name="application.datasource"
default="mydsn">, the variable is only set if it doesn't already exist. I
would guess this provides a slight performance increase which could really
add up under heavy use.
Todd Ashworth
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 04, 2000 1:33 AM
Subject: Re: What am I doing wrong?
> >The ## around the DSN are valid, especially if the #dsn# is a variable
that
> >contain the real DSN. This variable could be set just about anywhere,
but
> >is usually done in the Application.cfm (or other similar file) using the
> >syntax:
>
> ><cfparam name="dsn" default="mydsn">
>
> I do the same, but I have always used <cfset
application.datasource="mydsn">.
>
> Are there any performance implications either way, or are both just
different
> ways to do the same thing?
>
> --------
> Rob Keniger
>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> 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.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.
