• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Lack of interest [Suggestion] LIMIT to Session Query

#1
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.
 

Kier

XenForo Developer
Staff member
#5
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.