Mark as Read changes
by Rick Overman · in Site Feedback · 03/18/2005 (11:25 am) · 7 replies
Made changes to how unread post was calculated.
I had to reset EVERYONES unread in the process. Thank you for your understanding.
I had to reset EVERYONES unread in the process. Thank you for your understanding.
#2
WAAAAAAAAAAAAAAAAAAAHHHHHHHHHHHHHHHHHH!!!!!!!!!!!!!!!!!!!!!!!!!!!!
03/18/2005 (12:21 pm)
OMG!!!! It's all gone!!! I was saving up for the largest unread of all time. I had like half a million unread and counting.WAAAAAAAAAAAAAAAAAAAHHHHHHHHHHHHHHHHHH!!!!!!!!!!!!!!!!!!!!!!!!!!!!
#3
03/18/2005 (12:25 pm)
Muahah...it was a conspiracy!
#4
Either that, or my normally slow laptop+wireless connection is on meth.
03/18/2005 (1:22 pm)
Not sure what you did Rick, but it seems to have drastically increased post read performance!Either that, or my normally slow laptop+wireless connection is on meth.
#5
03/18/2005 (1:40 pm)
@ Stephen me too.
#6
Found an interesting feedback loop that would cause a db request storm and the bad thing is it occurs more frequently when large numbers of people were reading and posting on the forums. And our forum traffic has been up significantly lately.
Rearranged and number of queries and totally rewrote how unread posts were calculated, used some mysql 4+ magic and got some serious performance improvements. As I am writing this it seems so stupid, I mean how hard can calculating unread posts be? But when you have 1/4 million posts and special subscription and access restrictions the obvious straight forward query is actually too slow. I am doing something a little more devious and distributed now and all the work is done on the db server and not on the web server.
03/18/2005 (3:19 pm)
:) yes, it should be a bit faster. Found an interesting feedback loop that would cause a db request storm and the bad thing is it occurs more frequently when large numbers of people were reading and posting on the forums. And our forum traffic has been up significantly lately.
Rearranged and number of queries and totally rewrote how unread posts were calculated, used some mysql 4+ magic and got some serious performance improvements. As I am writing this it seems so stupid, I mean how hard can calculating unread posts be? But when you have 1/4 million posts and special subscription and access restrictions the obvious straight forward query is actually too slow. I am doing something a little more devious and distributed now and all the work is done on the db server and not on the web server.
#7
http://www.garagegames.com/mg/forums/result.thread.php?qt=30285
05/18/2005 (8:48 pm)
"read unread posts" seems to be broken currently. See this threadhttp://www.garagegames.com/mg/forums/result.thread.php?qt=30285
Torque Owner Tim Gift