Solved: 1 Year, 8 Months ago Unnecessary select queries on mybb_sessions
#3
Solved: 1 Year, 8 Months ago
(2020-01-12, 01:46 PM)Devilshakerz Wrote: With the Forum Display Options → Users Browsing this Forum setting off, these 2 queries shouldn't be executed:
https://github.com/mybb/mybb/blob/mybb_1...#L286-L297

With the Show Thread Options → Users Browsing this Thread setting off, these 2 queries shouldn't be executed:
https://github.com/mybb/mybb/blob/mybb_1...1522-L1533

The Online status is based on data in the mybb_users table, but there are other 2 queries related to the visitor's session (SELECT and UPDATE), executed early in the process. These only relate to specific rows, so it shouldn't have a significant impact on performance (and usually the SELECT one is faster than UPDATE).

Thanks so much! I'll give this a shot and see how it goes.
Reply


Messages In This Thread
RE: Unnecessary select queries on mybb_sessions - by mrdeltoid - 2020-01-12, 01:54 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)