We have a community with 15,000 odd members, often 600 online at the same time, works great using application scope method neil.
> -----Original Message----- > From: Robertson-Ravo, Neil (REC) > [mailto:Neil.Robertson-Ravo@;csd.reedexpo.com] > Sent: 07 November 2002 10:51 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] Online Users > > > I never said it wasnt :-) what I am saying is that the > application scope should be set little and read lots........ > Its not ideal to write to the app scope everytime a new user > logs in/out. > > If I use a db, I have one query to make which adds them to > the table, and I have one query to remove them on > logout....simple and fast. > > I am sure that constant read/read of the applicaion scope is > a degrader (but the fact you cannot get all user sessions is > a real arse in CF, well not natively).... > > As for speeding up the db, yes its pretty fast! > > N > > -----Original Message----- > From: Russ Michaels [mailto:snake@;snakepit.net] > Sent: 07 November 2002 10:43 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Online Users > > > Do a test neil. It is a known fact in the I.T industry that > memory is faster than disk. > > > -----Original Message----- > > From: Robertson-Ravo, Neil (REC) > > [mailto:Neil.Robertson-Ravo@;csd.reedexpo.com] > > Sent: 07 November 2002 10:21 > > To: '[EMAIL PROTECTED]' > > Subject: RE: [ cf-dev ] Online Users > > > > > > I disagree I would say reading and writing to a DB would be > > faster than consantly reading and writing to the Application > > scope (its using an SP > > btw). You certainly cannot say that its "massively slower > > than writing to > > memory", cause thats not the case. > > > > I have never liked using the application scope for such > > intensive requests as I have always seen degredation in > > performance especially when the scope starts to grow and > > become more complex. > > > > As for another way Russ, I told you, I am using a > > table...(possible temp, I have not decided yet.). > > > > Neil > > > > > > > > -----Original Message----- > > From: Steve Martin [mailto:steve.martin@;sequence.co.uk] > > Sent: 07 November 2002 10:15 > > To: [EMAIL PROTECTED] > > Subject: RE: [ cf-dev ] Online Users > > > > > > I'd still be interested to hear your rationale on why > > updating an application structure would be v.bad wheras you > > are happy to dump this info in a db which is massively slower > > than writing to memory. > > > > > -----Original Message----- > > > From: Robertson-Ravo, Neil (REC) > > > [mailto:Neil.Robertson-Ravo@;csd.reedexpo.com] > > > Sent: 07 November 2002 10:09 > > > To: '[EMAIL PROTECTED]' > > > Subject: RE: [ cf-dev ] Online Users > > > > > > > > > erm..... like I said, yes I know that can be done but with the > > > possibility of 600K users online at one time and the Application > > > structure being written > > > and read many times its not ideal........ in fact it would be > > > extremely > > > unwise to do so....... > > > > > > > > > -----Original Message----- > > > From: Paul Fennell [mailto:paul@;satachi.com] > > > Sent: 07 November 2002 10:07 > > > To: [EMAIL PROTECTED] > > > Subject: RE: [ cf-dev ] Online Users > > > > > > > > > bung that info in to an application strc then > > > wrap it and lock it > > > > > > > > > > > > -----Original Message----- > > > From: Robertson-Ravo, Neil (REC) > > > [mailto:Neil.Robertson-Ravo@;csd.reedexpo.com] > > > Sent: 07 November 2002 09:56 > > > To: '[EMAIL PROTECTED]' > > > Subject: RE: [ cf-dev ] Online Users > > > > > > > > > :-) > > > > > > I need to have a list of ALL users logged into the system at one > > > time... I log their UserID, time of login etc... > > > > > > N > > > > > > -----Original Message----- > > > From: Steve Martin [mailto:steve.martin@;sequence.co.uk] > > > Sent: 07 November 2002 09:53 > > > To: [EMAIL PROTECTED] > > > Subject: RE: [ cf-dev ] Online Users > > > > > > > > > OK, let's look at this again, from the top. What specific user > > > information do you require and for what purpose? > > > > > > > -----Original Message----- > > > > From: Robertson-Ravo, Neil (REC) > > > > [mailto:Neil.Robertson-Ravo@;csd.reedexpo.com] > > > > Sent: 07 November 2002 09:19 > > > > To: '[EMAIL PROTECTED]' > > > > Subject: RE: [ cf-dev ] Online Users > > > > > > > > > > > > LOL :-) > > > > > > > > OK Steve, What I can't see from your suggestion is this : > > > > how do I get > > > > *all* of the users into the session scope? of course I > understand > > > > fully how to get them into the application scope (to be shared) > > > > but I am unsure on how > > > > you get all of the users into a session scope which can then > > > > be queried. > > > > Surely each users session is independent? > > > > > > > > Neil > > > > > > > > > > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > From: Steve Martin [mailto:steve.martin@;sequence.co.uk] > > > > Sent: 06 November 2002 17:47 > > > > To: [EMAIL PROTECTED] > > > > Subject: RE: [ cf-dev ] Online Users > > > > > > > > > > > > By who's criteria? > > > > The session scope is there for storing login > information of this > > > > nature. Slam in some RAM if you feel that your server > can't cope. > > > > 600 users is a > > > > pretty teeny weeny small number by any server's standards. > > > > > > > > My usual advice is to avoid trying to come up with > > esoteric software > > > > engineering solutions to workaround physical constraints > > when such > > > > constraints can be overcome by spending 50p on some more memory. > > > > > > > > > -----Original Message----- > > > > > From: Robertson-Ravo, Neil (REC) > > > > > [mailto:Neil.Robertson-Ravo@;csd.reedexpo.com] > > > > > Sent: 06 November 2002 17:12 > > > > > To: '[EMAIL PROTECTED]' > > > > > Subject: RE: [ cf-dev ] Online Users > > > > > > > > > > > > > > > well,, after a quick check, the amount of users within the > > > > > system could be > > > > > 600+ at anyone time..... > > > > > > > > > > bit big for the session scope?! > > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > From: Steve Martin [mailto:steve.martin@;sequence.co.uk] > > > > > Sent: 06 November 2002 16:44 > > > > > To: [EMAIL PROTECTED] > > > > > Subject: RE: [ cf-dev ] Online Users > > > > > > > > > > > > > > > I just store login information in the session scope > which takes > > > > > care of flushing itself when the timeout is reached. Why > > > > specifically are you > > > > > storing such information in a db? > > > > > > > > > > > -----Original Message----- > > > > > > From: Robertson-Ravo, Neil (REC) > > > > > > [mailto:Neil.Robertson-Ravo@;csd.reedexpo.com] > > > > > > Sent: 06 November 2002 16:31 > > > > > > To: '[EMAIL PROTECTED]' > > > > > > Subject: [ cf-dev ] Online Users > > > > > > > > > > > > > > > > > > This is a no brainer and I must be having a brain fart.... > > > > > > > > > > > > We have an online table which holds records for each user > > > > > > logged onto the system after login. > > > > > > These rows have a date logged on etc, and indeed this works > > > > > > well when the > > > > > > user signs off as expected (as this removes the rows in > > > question) > > > > > > > > > > > > however, what process do you guys have in place when a user > > > > > > does NOT sign > > > > > > off and simply closes the browser and does not return for > > > > a few days > > > > > > later...? > > > > > > > > > > > > It means that they remain 'online' in the DB...... > > > > > > > > > > > > What do you guys have in place... any ideas? > > > > > > > > > > > > Neil > > > > > > > > > > > > -- > > > > > > ** Archive: > > > > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > > > > > > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > > > > For additional commands, e-mail: > > [EMAIL PROTECTED] > > > > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > -- > > > > ** Archive: > > > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > > > -- > > > > ** Archive: > > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: > > [EMAIL PROTECTED] For > > > human help, e-mail: [EMAIL PROTECTED] > > > > > > > > > -- > > > ** Archive: > > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: > > [EMAIL PROTECTED] For > > > human help, e-mail: [EMAIL PROTECTED] > > > > > > -- > > > ** Archive: > > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: > > [EMAIL PROTECTED] For > > > human help, e-mail: [EMAIL PROTECTED] > > > > > > > > > > -- > > ** Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: > > [EMAIL PROTECTED] For human help, e-mail: > > [EMAIL PROTECTED] > > > > -- > > ** Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: > > [EMAIL PROTECTED] For human help, e-mail: > > [EMAIL PROTECTED] > > > > > > > > -- > > ** Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: > > [EMAIL PROTECTED] For human help, e-mail: > > [EMAIL PROTECTED] > > > > -- > > ** Archive: > http://www.mail-archive.com/dev%> 40lists.cfdeveloper.co.uk/ > > > > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > For additional commands, e-mail: > > [EMAIL PROTECTED] For human help, e-mail: > > [EMAIL PROTECTED] > > > > > > -- > > ** Archive: > http://www.mail-archive.com/dev%> 40lists.cfdeveloper.co.uk/ > > > > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > For additional commands, e-mail: > > [EMAIL PROTECTED] For human help, e-mail: > > [EMAIL PROTECTED] > > > > -- > > ** Archive: > http://www.mail-archive.com/dev%> 40lists.cfdeveloper.co.uk/ > > > > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > For additional commands, e-mail: > > [EMAIL PROTECTED] For human help, e-mail: > > [EMAIL PROTECTED] > > > > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
