OK,
This is strange one as we have probably all led to believe that a Database
is the place to store Client vars but some recent tests have shown that
doing so, at least on CFMX 6.1 (full patched) you suffer quite a serious
performance degredation.
Try running the following code on a server which has Client Variable set to
a database (ignore any crapola code, it's a test ;-):
<cfapplication name="foomanchu"
sessionmanagement="Yes"
setclientcookies="Yes"
sessiontimeout="#createtimespan(0,4,0,0)#"
applicationtimeout="#createtimespan(1,0,0,0)#"
clientmanagement="Yes">
<cfif ISDefined("flubbalubba")>
<cfif flubbalubba EQ "jubbly">
<cfset client.dbtype="foo">
<cfset client.dsname="foo">
<cfset client.clientname="foo">
<cfelseif flubbalubba EQ "foo">
<cfset client.clientname="foo">
<cfset client.dbtype="foo">
<cfset client.dsname="foo">
</cfif>
<cfelseif NOT ISDefined("Client.dbtype")>
<cfset client.clientname="foo">
<cfset client.dbtype="foo">
<cfset client.dsname="foo">
</cfif>
Note the Parsing time.........now switch to store the Client vars in the
registry and run it again....you will notice what seems to be a massive
performance INCREASE over using a database (this was confirmed on 2 separate
server farms).
Anyone else confirm this as I am not sure if it's a bug or not.
Neil
This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information which is
confidential and may also be privileged. It is for the exclusive use of the
intended recipient(s). If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful. If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910. The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
