Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

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?

Also, login cookie expiry was reduced from 1000 days to 100 days.

(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...

asked 23 Oct '13, 06:10

Volker%20Barth's gravatar image

Volker Barth
accept rate: 34%

edited 23 Oct '13, 06:15

I wonder what is going to happen to the MySybase based authentication as that site is wound down?

(23 Oct '13, 06:41) Justin Willey

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.

permanent link

answered 23 Oct '13, 06:46

Graeme%20Perrow's gravatar image

Graeme Perrow
accept rate: 54%

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 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:

alt text

(23 Oct '13, 08:05) Volker Barth

Hmmm, yet another page from that has disappeared. Thanks for pointing that out - We'll get the link fixed.

(23 Oct '13, 08:24) Mark Culp

The page has been displaying that for weeks, but the link from it to the EBFs still works.

(23 Oct '13, 09:34) Breck Carter
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 23 Oct '13, 06:10

question was seen: 1,141 times

last updated: 23 Oct '13, 09:34