Hi Andrew, Could you point you which part of the code hits the DB everytime? I currently have my login 'scripts' (more of files stored in its old folders) called via template when needed at work. I thought this is a pretty efficient and simple way of authentication, just wondering where this part of the code that hits the DB unnecessarily.
Thanks in advance, KC Kuok On Apr 26, 3:53 pm, Andrew Scott <[EMAIL PROTECTED]> wrote: > Well I will say it is a very well written article, but it hits the database > each and every request now although minimal impact it can create a > networking bottleneck on heavy sites. > > The most common and preferred method would be to once it is authenticated to > stick the info into a session variable, and check against that before having > to re hit the database for a valid login. > > As far as request goes that only lives for the current request, so by > placing the data into that scope you are running that code each and every > page request and again, this is an overhead that can be cut with a change in > the way it is coded. > > Don't get me wrong, each to their own. Personally that method of hitting the > DB, and then storing in the request scope is an overhead that really should > be avoided if possible. > > Andrew Scott > Senior Coldfusion Developer > Aegeon Pty. Ltd.www.aegeon.com.au > Phone: +613 8676 4223 > Mobile: 0404 998 273 > > > > -----Original Message----- > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf > > Of KC Kuok > Sent: Thursday, 26 April 2007 3:14 PM > To: cfaussie > Subject: [cfaussie] Re: Request VS Application Scope > > I thought it was a fairly good tutorial link... care to enlighten me > which part was running code unnecessarily? > > Cheers. > KC Kuok > > On Apr 26, 2:13 pm, Andrew Scott <[EMAIL PROTECTED]> wrote: > > That is a typical example of running code unnecessarily.. > > > Andrew Scott > > Senior Coldfusion Developer > > Aegeon Pty. Ltd.www.aegeon.com.au > > Phone: +613 8676 4223 > > Mobile: 0404 998 273 > > > -----Original Message----- > > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On > Behalf > > > Of elAdi > > Sent: Thursday, 26 April 2007 1:50 PM > > To: cfaussie > > Subject: [cfaussie] Re: Request VS Application Scope > > > Here's a tutorial that implements user authentication through > > application.cfc and uses request variables. Might shed some light into > > it - not theoretically, but practically. > > >http://www.trajiklyhip.com/tutorials/loginSecurityCF7/loginSecurityCF... > Hide quoted text - > > > - Show quoted text -- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
