Re: Getting forum page number
You mean on the regular topic page? Yeah it would just add one query.
On a low to medium activity site it should be okay.
I think there’s an index on topic_time so mysql shouldn’t have too much of a workout.
>= switch aroo may be logic confusion on my part between whether to use DESC or ASC.
One makes the list start with the current topic time, the other way makes it end with the time.
In theory the count should be easier with
<= and if you have to change DESC to ASC.