[user] save the last visit datetime #454

Closed
opened 2026-10-04 23:59:30 +02:00 by adam · 0 comments
Owner

In the edit user popin, we show the last visit date and time. This date is taken from the history table, which leads to 2 problems:

  1. if the table gets big (which is often a problem, as long as we have not implemented #370 ) the SQL query to get the last visit can take very long (several seconds)

  2. if the history is disabled, we show an incorrect information

To avoid these problems, we can simply register the date and time in a new column users.last_visit

In the edit user popin, we show the last visit date and time. This date is taken from the history table, which leads to 2 problems: 1) if the table gets big (which is often a problem, as long as we have not implemented #370 ) the SQL query to get the last visit can take very long (several seconds) 2) if the history is disabled, we show an incorrect information To avoid these problems, we can simply register the date and time in a new column users.last_visit <!-- github-sync-id:153967047 -->
adam closed this issue 2026-10-04 23:59:31 +02:00
Sign in to join this conversation.
No labels
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: adam/Piwigo#454