User: dries Branch: HEAD Date: Sat, 07 May 2005 11:39:55 +0000 Modified files: /database database.mysql database.pgsql updates.inc /includes session.inc /modules user.module Log message: - User module improvements: added an 'access' column to the users-table to keep track of the user's last access. In turn, this allowed me to: 1. Optimize the "Who's online" block. On drupal.org, the "Who's online" block requires 32 SQL queries. With this patch, only 2 queries are left (eliminated 30 SQL queries), and one of the two remaining queries became appr. 20 times faster. 2. Correct the "Last access" column in the user administration overview table. The presented data was not accurate, which led to the column being removed. You can now sort users by 'last access'. Links: http://cvs.drupal.org/diff.php?path=drupal/database/database.mysql&old=1.183... http://cvs.drupal.org/diff.php?path=drupal/database/database.pgsql&old=1.120... http://cvs.drupal.org/diff.php?path=drupal/database/updates.inc&old=1.114&ne... http://cvs.drupal.org/diff.php?path=drupal/includes/session.inc&old=1.15&new... http://cvs.drupal.org/diff.php?path=drupal/modules/user.module&old=1.468&new...