[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Adding Users
-----BEGIN PGP SIGNED MESSAGE-----
On Tue, 9 Feb 1999, Micah Yoder wrote:
> "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 still an arbitary number. Having a few orphined records that never
get utilized are the least of our problems IMHO. If and only if the table
gets too large do we need to start purging records.
> > 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.
I think it's a useful stat to keep anyways. We can run reports to see who
is the most active, and various percentages (10% of the people have
submitted >5 entries etc.)
> > 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.
Jason, can you clarify the data structure in the TTL field? Is it a true
TTL (a counter) or is it really an "expiration date"? I think the field
should be named appropriately, or people like me who work with TTL's in
the classical sense are going to get confused. :-)
- --
Aaron Turner | Either which way, one half dozen or another.
aturner@pobox.com | Check out the Red Hat Linux User's FAQ Online!
www.pobox.com/~aturner | http://www.pobox.com/~aturner/RedHat-FAQ/
All emails from this account are PGP signed. Lack of a signature is "bad".
PGP Key fingerprint = FB E1 CE ED 57 E4 AB 80 59 6E 60 BF 45 1B 20 E8
-----BEGIN PGP SIGNATURE-----
Version: 2.6.2
iQCVAwUBNsHV0TM3jpXy1kJtAQHt+QP9F1lNhdLAJa/7Ajckp54XmIuKeKzF6KwE
Qba88N7XwqRaW0PzKpzdBPJpAzytVHNDA0WnUQslIdr2UF2GdlTdoRfVlYf67oR4
w9YUYKVpBe77cIfnARslmgLXjKnWesID8dDRfKiiWoRnmZhB93tMBZECZ7xn/gwB
Nq0/cibY0cA=
=BwdO
-----END PGP SIGNATURE-----