Re: Adding Users

[Micah Yoder <LYoder@cyberis.net>]

"Aaron D. Turner" wrote:

> The only comment I have is regarding the user expiring/deleting.  I'm cool
> with purging from the DB the records after 30 days that are never used.
> However once the user has logged in once their account should last
> forever.

Maybe.  But there will probably be a few people that never log in
again.  I guess it doesn't matter much.  Perhaps a LONG TTL like a
year???

> It's not like we're going to get 100,000's of user records.  Nothing more
> fustrating than trying to login with to an account that doesn't exist
> anymore!  And I doubt that people would re-create an account many time
> before getting completely fed up.

Right...

> Don't have the schema available, but it might be nice to have a
> LastLoginDate field, so if later on down the road we want to impliment
> this feature for some reason, we will already have the info.  Also the

That might be better.  Only problem is you have to update the record
every login.  Not necessarily a big deal, but something we wouldn't have
to do otherwise.

> problem with TTL's is that you have to have a query run each day to
> decrement all the records.  Seems more efficiant to do a read and
> evaluation than a read, decrement, and write.

The way I understand it is that TTL holds a date, not the number of
days.  So you wouldn't have to update it every day.  Even if you did,
the SQL to do it would be quite simple, and could be run at night.