Marcello Costagliola 33c4b726e7 Find a direct room with one query instead of checking every one ...

Opening a direct room looked for an existing one by loading every direct
room on the account and comparing its member ids in Ruby, two queries per
room, on each click. The cost grows with the account: about 0.3 s at 1,000
direct rooms and 3 s at 10,000. Asking SQL for the room among the first
user's memberships whose member set is exactly the given users finds the
same room in one query, however many direct rooms there are.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01JVFo3Lt9T8M5NR7KxVvsZ2

2026-10-05 04:06:17 +02:00

..

direct_test.rb

Find a direct room with one query instead of checking every one

2026-10-05 04:06:17 +02:00

open_test.rb

Hello world

2025-08-21 09:31:59 +01:00