BIKEPGH MESSAGE BOARD ARCHIVE

Sweet!

Spiffy!

so pretty... everything works better and faster! especially the login.

I'm getting a "forum not found" message on FS/WTB and the Bike Advocacy forums. Other'n'at, looks real spiffy! Thanks!

BTW, "green and leafy?"

Yay, the FS/WTB and the Bike Advocacy forums work! Thanks again!

Looks good, although some threads appear to have their final posts eaten.

See "hi", two threads below this: listed at 6 messages, with the latest from me; displays 3 messages.

so far i like it a lot. i wonder if posts automatically close unclosed tags, so we can do away with the four consecutive posts that go to the same link. those were fun, though.

so far, my only complaint--and this might be just a function of my lack of understanding about the new setup--is that: i REALLY liked the feature that showed you which threads had new posts in them, and that seems to be gone. that feature is how i tend to browse all forums, and if it's there and i'm just missing it, someone please let me know!

This is way better.

there were times when i was too lazy to offer my

unasked for opinion because i didnt feel like logging in.

the new feature that addresses which threads have new posts is RSS and "freshness"

I guess there's no way to do the bike icon thing. Totally new message board system. They're constantly developing it, though, so who knows what the future will bring.

so far i like it a lot. i wonder if posts automatically close unclosed tags, so we can do away with the four consecutive posts that go to the same link. those were fun, though.

good theory. was wondering about that myself.

One thing I want to change i linking to photos. The

It looks like there are some plugins for the bbpress software to allow some HTML tags in posts.

this new forum setup is awesome! the only thing i'm a little confused about is some of my replies seem to have disappeared from posts. anyone else notice this?

yeah we've noticed. i think they're the threads with double or triple posts, but we're checking into it.

why does it say i'm green and leafy?

i think because you've posted a lot. i'll have to get the run down from Nathan. Newbie is obvious as is "frequenter" but "member" and "green and leafy" is not so much, albeit pretty funny.

clicked on links are now darker and linked images are supported

Testing (green and leafy) images

Is it just me, or does it seem to take a very long time to bring up this board's main page? (i.e., a lot longer than the old one)

Granted my machine is old and slow (933 MHz), but I didn't used to be able to go out to the kitchen, pour myself a cup of coffee and get back before the page came up.

Funny, it has been really slow for me, until I saw this post in my RSS. It loaded quickly.

It's slower than molasses in January. We're looking into it, but if anyone specializes in MySQL who wouldn't mind taking a look under the hood, we'd really appreciated it. Here's what we got from Pair.com:

"That URL actually is working, but is very, very slow. This is because of

the many slow queries that are being run on this database (194 so far

today). These queries are examining about 2.4 million rows to return 10.

Here is an example of a recent query:

# Time: 081006 17:42:46

# User@Host: bikepgh[bikepgh] @ [209.68.4.180]

# Query_time: 138 Lock_time: 0 Rows_sent: 10 Rows_examined: 2494186

SELECT forum_id, topic_id FROM bb_topics WHERE topic_last_post_id IN

(SELECT MAX(topic_last_post_id) FROM bb_topics WHERE topic_status=0 GROUP

BY forum_id);

You should purge data from this database and/or restructure your queries

to be more efficient."

Not sure how in the hell there are 2.4 million rows. This msg board ain't that big. Please help!!!

Do y'all have the MySQL cache enabled?

Long thread here about bbpress and caching.

How many total records are in bb_topics? Can you post the result of

EXPLAIN SELECT forum_id, topic_id FROM bb_topics WHERE topic_last_post_id IN

(SELECT MAX(topic_last_post_id) FROM bb_topics WHERE topic_status=0 GROUP

BY forum_id);

and

SHOW INDEX from bb_topics

Things have been really weird for me since the upgrade too. SLOW loading, have to log in every time I come back to site, image stuff, etc.

I'm no database pro, but I'll give a shot at dissecting the query:

"SELECT forum_id, topic_id FROM bb_topics" tells the database to look through every topic and to look at its forum_id and topic_id. "WHERE topic_last_post_id IN(" tells the database to only return these values if topic_last_post_id is in the max of the set returned by the second query, "SELECT MAX(topic_last_post_id) FROM bb_topics WHERE topic_status=0 GROUP BY forum_id". The problem appears to be that the second query has to be executed for every single row in bb_topics, which means the number of operations is on the order of the square of the number of rows in bb_topics. Ouch.

That's why 2.4 million rows are examined: it goes over the same rows, probably about sqrt(2.4 million) rows, a whole bunch of times.

I'll give a shot at rewriting this thing.

Thought:

Someone should teach the BBPress developers about "comments."

I don't know PHP and don't have time to delve into the sparsely-commented code of BBPress to get an idea of where, exactly, this query comes from. However, I can offer an idea that'd hopefuly take performance closer to O(nlogn) than O(n^2), assuming it isn't already used: put an index on topic_last_post.

An article on the topic is here:

http://www.databasejournal.com/features/mysql/article.php/1382791

I believe the command you'd want to run is

ALTER TABLE bb_topics ADD INDEX(topic_last_post_id);

Looks like Nathan was able to fix it by eliminating the "most recent poster" plug-in.

Just tested it out. It's friggin' QUICK now. Thx!!

Images seem to work OK now, too! Double thx!!

(See full story under Eye Candy.)