Lack of interest [Suggestion] LIMIT to Session Query

DregondRahl

Member
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.

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

Laric

Active member
But it would have an effect anyhow especially if the mysql server is on another host wouldn't it?
 

Kier

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.
 
Top