|
Today, I had to re-enter my login credentials for this forum. That has fortunately not been necessary for a long time... Is the need to re-login because of the following change according to yesterday's "Maintenance log" entry?
(An expiry timespan for 1000 days could not be reached for this forum, as the site itself is not that old, methinks...) If so, I guess I would not consider this an improvement... |
|
Yes, that's why you need to log in again. The way Django saves login information is through a row in a table containing session data. A new row is created every time you connect with a different browser session, i.e. if you connect to the forum and authenticate (whether manually or through a cookie), then close and re-open the browser and do it again, that's two rows. Unless you manually click "Logout", the rows are not deleted until they expire. When I restarted the forum, there were over 2.8 million rows in this table, taking up about 95% of the total database size. I've moved the table in question to its own dbspace to reduce fragmentation, and I did an unload/reload on the database which reduced its size from 1.1 GB to about 80 MB. We also decided that having three years worth of rows in this table was a waste, and so we reduced the cookie expiry time to 100 days. OK, that's understood. I hope my OpenID expires not that early:)
(23 Oct '13, 07:53)
Volker Barth
Comment Text Removed
Wow... you can usually predict which one will be The Table From Hell for any given application, but session? Who'da thunk it? ...maybe that's the problem healthcare.gov is having :)
(23 Oct '13, 07:57)
Breck Carter
Replies hidden
Well, Graeme will have a backup, so he can now analyse who of both of us had had more login time... Just in case the NSA does not already know how I've spent my time:) Aside: I just tried to read the "Privacy Policy" of this forum (you know, German folks are easily worried with those rules:) - but that's what I got:
(23 Oct '13, 08:05)
Volker Barth
Hmmm, yet another page from sybase.com that has disappeared. Thanks for pointing that out - We'll get the link fixed.
(23 Oct '13, 08:24)
Mark Culp
The mysybase.com page has been displaying that for weeks, but the link from it to the EBFs still works.
(23 Oct '13, 09:34)
Breck Carter
|
I wonder what is going to happen to the MySybase based authentication as that site is wound down?