Where's the TOW?
06-22-2007 | 11:42 PM
#28
Out Of Control!!
Joined: Oct 2005
Posts: 25,523
Likes: 0
From: Scripps Ranch, San Diego, CA
'05 C55 AMG '15 Jeep SRT '11 G37S
06-23-2007 | 12:06 AM
#30
MBWorld Fanatic!
Joined: May 2003
Posts: 1,348
Likes: 0
From: Northern NJ
2014 BMW 550i
I wonder how many posts total were in the TOW?
The speed had been very slow recently, but it is very snappy today.
From a back end database perspective, when you have a system that is optimized for maybe max of 200 posts or so, with an average much, much lower, thousands of posts can't be good.
I would think the only practical thing to do would be to split it up, and lock all of the archived threads.
Although, with the TOW gone, it does make the post counts of us "normals" seem all the better.
The speed had been very slow recently, but it is very snappy today.
From a back end database perspective, when you have a system that is optimized for maybe max of 200 posts or so, with an average much, much lower, thousands of posts can't be good.
I would think the only practical thing to do would be to split it up, and lock all of the archived threads.
Although, with the TOW gone, it does make the post counts of us "normals" seem all the better.
06-23-2007 | 01:20 AM
#36
Out Of Control!!
Joined: Jul 2002
Posts: 28,933
Likes: 11
I wonder how many posts total were in the TOW?
The speed had been very slow recently, but it is very snappy today.
From a back end database perspective, when you have a system that is optimized for maybe max of 200 posts or so, with an average much, much lower, thousands of posts can't be good.
I would think the only practical thing to do would be to split it up, and lock all of the archived threads.
Although, with the TOW gone, it does make the post counts of us "normals" seem all the better.
The speed had been very slow recently, but it is very snappy today.
From a back end database perspective, when you have a system that is optimized for maybe max of 200 posts or so, with an average much, much lower, thousands of posts can't be good.
I would think the only practical thing to do would be to split it up, and lock all of the archived threads.
Although, with the TOW gone, it does make the post counts of us "normals" seem all the better.
The TOW thread was about 250k posts, it was a literal ***** to move and manage. We're going to run experimentations for a week to see how we can fine tune the max keep alives and process spawning. It'll be a fun summer for session and Mr. Vanos.
For what it's worth, the database is corrupted beyond belief and it's surprising that we've gotten so far on what it is. If you've got any good ideas, please let the staff know -- I know there are a bunch of system guru's out there!
06-23-2007 | 01:50 AM
#38
Out Of Control!!
Joined: Dec 2004
Posts: 14,212
Likes: 8
From: Boston, MA
00 MB ML55, 91 Toyota Supra Turbo(sold), 06 E500(gone), 03 BMW M3
06-23-2007 | 01:51 AM
#39
Out Of Control!!
Joined: Dec 2004
Posts: 14,212
Likes: 8
From: Boston, MA
00 MB ML55, 91 Toyota Supra Turbo(sold), 06 E500(gone), 03 BMW M3
We're really working on making mbworld.org a lot snappier. The biggest problem is that we all lead lives in reality as well. Once one of the staff has time to start optimizations, another one has a race to attend, or a final to take, or a wife (LOL).
The TOW thread was about 250k posts, it was a literal ***** to move and manage. We're going to run experimentations for a week to see how we can fine tune the max keep alives and process spawning. It'll be a fun summer for session and Mr. Vanos.
For what it's worth, the database is corrupted beyond belief and it's surprising that we've gotten so far on what it is. If you've got any good ideas, please let the staff know -- I know there are a bunch of system guru's out there!
The TOW thread was about 250k posts, it was a literal ***** to move and manage. We're going to run experimentations for a week to see how we can fine tune the max keep alives and process spawning. It'll be a fun summer for session and Mr. Vanos.
For what it's worth, the database is corrupted beyond belief and it's surprising that we've gotten so far on what it is. If you've got any good ideas, please let the staff know -- I know there are a bunch of system guru's out there!
06-23-2007 | 12:15 PM
#44
MBWorld Fanatic!
Joined: Dec 2005
Posts: 2,158
Likes: 0
From: asdfasdf
One with 4 wheels
06-23-2007 | 02:05 PM
#46
MBWorld Fanatic!
Joined: May 2002
Posts: 8,189
Likes: 1
From: SF
2007 VW GTI
Every time someone loaded the TOW forum, the database had to query 222,000+ posts. And you wonder why the database is slow? Imagine if your email client had to load a thread with that many posts!
The thread is not gone, it is just in hiding. We will experiment this week to see if the regular traffic loads stay the same and if performance improves. If so, we'll see how to handle TOW.
We aren't just going to throw away your data.
That being said, 22,000 posts in one thread? GET A LIFE!
The thread is not gone, it is just in hiding. We will experiment this week to see if the regular traffic loads stay the same and if performance improves. If so, we'll see how to handle TOW.
We aren't just going to throw away your data.
That being said, 22,000 posts in one thread? GET A LIFE!
06-23-2007 | 03:06 PM
#48
Admin Alumni
Joined: Nov 2001
Posts: 8,143
Likes: 18
See Garage
Meantime, I'm told the first step in any 12-step process is to capitulate and admit one has a problem. Those of you who have lost several hundred or thousands in your post counts need to wake up to your problem, as many already have noted here.
There will be a step two class forming next week. Stay tuned, LOL!
06-23-2007 | 03:32 PM
#49
Out Of Control!!
Joined: Oct 2005
Posts: 25,523
Likes: 0
From: Scripps Ranch, San Diego, CA
'05 C55 AMG '15 Jeep SRT '11 G37S
Every time someone loaded the TOW forum, the database had to query 222,000+ posts. And you wonder why the database is slow? Imagine if your email client had to load a thread with that many posts!
The thread is not gone, it is just in hiding. We will experiment this week to see if the regular traffic loads stay the same and if performance improves. If so, we'll see how to handle TOW.
We aren't just going to throw away your data.
That being said, 22,000 posts in one thread? GET A LIFE!
The thread is not gone, it is just in hiding. We will experiment this week to see if the regular traffic loads stay the same and if performance improves. If so, we'll see how to handle TOW.
We aren't just going to throw away your data.
That being said, 22,000 posts in one thread? GET A LIFE!
gee, and to think I donated to your bike ride.
