Projects tigase _server server-core Issues #567
Improve TigUserLogout (#567)
wojciech.kapcia@tigase.net opened 9 years ago
Due Date
2015-09-17

Description from thread https://projects.tigase.org/boards/4/topics/5687:

in the mysql-schema-4-sp.sql the procedure TigUserLogout is defined as:

create procedure TigUserLogout(_user_id varchar(2049) CHARSET utf8)
begin
update tig_users
set online_status = greatest(online_status - 1, 0),
last_logout = CURRENT_TIMESTAMP
where user_id = _user_id;
end

why in the where clause is used directly the "_user_id" (that is not indexed on mysql) instead of "sha1_user_id = sha1(lower(_user_id))" as done in the other stored procedures?
wojciech.kapcia@tigase.net commented 9 years ago

Applied in changeset commit:tigase-server|083c7fcb.

issue 1 of 1
Type
Task
Priority
Normal
Assignee
RedmineID
3496
Version
tigase-server-7.1.0
Spent time
3h
Issue Votes (0)
Watchers (0)
Reference
tigase/_server/server-core#567
Please wait...
Page is in error, reload to recover