Unless it's a missing index or something? - Peter
-----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 14 May 2004 10:38 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] Client Vars : Registry or Database 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] -- 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]
