Of course registry is quicker, that's directly accessing memory. Database storage is accessing a database on a disk on another server.
I don't think you understand the reasons why and when you should use the registry or database. If it's your own dedicated server with only your site on it, use the registry, and make sure you have enough memory in the server to cope if your doing a lot of client storage. If your running a shared hosting server with 100's of websites, you should use the database, because of the potential problems with the number of sites and number of client vars, and amount of memory, and possible registry corruption. It is quite easy to bring a server to it's knees if it is using the registry for client storage. So ideally you want this completely disabled on a shared server so clients cannot even specify it in the cfapplication. If your going to use registry on a shared server make sure you have bucket loads of memory and have a scheduled registry backup. Russ > -----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]
