Yeah, understand all that but if the performance degredation is apparent with this test code, imagine what its gonna be like across the board with multiple!
-----Original Message----- From: Peter Harrison [mailto:[EMAIL PROTECTED] Sent: 14 May 2004 11:26 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Client Vars : Registry or Database I could be wrong, but the whole point of the database option was to cope with a larger number of concurrent sessions. Possibly even some fancy integration with your own applications. With a server farm your load is balanced out, and hopefully you have fewer concurrent sessions per box. So use what is fastest and copes with what you expect to throw at it. However, what I can't tell you is how does the registry cope after a long period of time with disk fragmentation issues (anything else? bloating? out of registry space? etc)? - 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] 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]
