First, sorry for the multiple posts to the list...I was not getting any mail from the
list for several hours yesterday, and thought something was wrong....
OK, now I see a reason for using application scope variables. An in fact, I have
written web site where I have cashed large "setup" queries in application variables.
It would make sense to lock those, and not use request varibles....Thanks!
At 11:24 AM 9/28/00 +0200, BOROVOY Noam wrote:
>For simple variables you're right, request should be faster than application
>because the set is fast and you don't need locking.
>
>For complex large variables like an array, structure or query it's more
>efficient in application scope as the set is long and many times involves a
>db hit, so locking is a small performance penalty especially with read only
>locks.
>
>HTH,
>Noam
>
> ----------
> From: Douglas M. Smith [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, 27 September 2000 22:57
> To: Fusebox
> Subject: Re: Why use shared scope variables?
>
> Hi Stephen,
>
> So, request variables are only in memory for as long as the HTML
>page request is actually happening. As soon as the page request is over,
>they go away.
>
> What is your opinion on the performance drain of using request
>variable vs. application variables on a very large site?
>
> Since request variables don't have to be locked, as long as you have
>enough memory on your server, the performance should be superior to
>application variables, no?
>
> What is your opinion?
>
> Thanks,
>
> Douglas Smith
>
>
>------------------------------------------------------------------------------
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
====================================================
Douglas M. Smith - Database Architect/Web Integration Specialist
====================================================
TeraTech Inc - Tools for Programmers(tm)
VisualBasic, Web (ColdFusion and ASP), Math and Statistics,
Access, SQL, programming tools & consulting
100 Park Ave, Suite 360, Rockville MD 20850 USA
Voice: 301-424-3903, Fax: 301-762-8185
http://www.teratech.com
====================================================
Email: [EMAIL PROTECTED]
Mobil/Cell Phone: (240) 601-5520
ICQ: 41044319
====================================================
Do you need a group calendar or scheduler?
How about a free ColdFusion Tag and Function Reference?
Go to http://www.teratech.com/freestuff.cfm
====================================================
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
