Lack of interest [Suggestion] LIMIT to Session Query

Sessions can get quite large for an active community, so it would appropriate i think to add LIMIT 1 to the session query, so it stops searching after it find the one its looking for.

SELECT session_data, expiry_date
FROM xf_session
WHERE session_id = ?
Its not a major change but for a lot of sessions it can have some improvement.


XenForo developer
Staff member
LIMIT works by doing the query, then extracting a collection of results.

When the query can only return a single result, by virtue of {unique_key} = {value}, then adding a LIMIT clause could not have any effect whatsoever.