[_ck_]

Confirmed working in 0.9.0.4 with apparent speed boost.

Those using my mini-plugin, you MUST delete it when using 0.9.0.4 or 1.0-alpha-5 or you’ll find that all topics disappear.

[marky]

Thanks for the speedy reply. I just installed the Human Test plugin today, thankfully. I wish I knew about it sooner; perhaps I wouldn’t have this mess to clean up now.

At any rate, I’m not integrated—it’s a stand-alone forum. I’m running MySQL 4.1.16, according to phpMyAdmin.

[chrishajer]

Hopefully, you’ve added the Human Test plugin to prevent spam registrations.

https://bbpress.org/plugins/topic/human-test/

I don’t know of a way to mass moderate users in bbPress. If you’re integrated with WordPress, I believe there is a mass edit for users available there.

If you’re not integrated, I think you need to use some SQL with the database directly. If you need that, please post the MySQL version you are using (since subqueries were added in MySQL 4.1, and the solution would be different if you’re using MySQL prior to 4.1)

I’ve been playing with the SQL to do this, but my MySQL version is 4.0.27, which does not support subqueries.

[Ben L.]

I’m on the current trunk as of writing this post. (1903) I’ll try testing the live forum.

Edit: Using the default theme made the problem go away, but the line of code that shows the edit/delete/undelete links is exactly the same as Kakumei’s and there’s no functions.php file.

[chrishajer]

Rather than trying your theme and plugins on another installation, how about turning off the plugins and trying the default theme on your live forums? Testing the other way is not a 100% test.

Do you know what revision of trunk you’re using? I installed trunk two years ago, but it was a much different version then.

[John James Jacoby]

Yes I do have the role map setup in the bbPress admin area. I also installed the additional role map plugin you made just to see what it was for, and retried these steps with and without it active.

I think this evening I’m going to retest this on stock installs of both to see if any of my plugins are conflicting. I am using the Register Plus plugin on the WP side, so I suppose it’s possible it could conflict (as far as I know it uses the stock WP registration and user activation methods to create them though.)

[virginiagirl]

I am comparing the two right now to see if I deleted something important. Do you know which php file I should be looking in? I did not integrate the forum with WordPress and am using the latest version of bbPress (I just installed it a few days ago). The only plugins I am using is the Akismet plugin. I guess I must have deleted something although I’m not sure what!

[-skipper-]

Based on Scoun theme from Mike Lothar.

Plugins used:

– Akismet

– Human Test for bbPress

– bbpress SEO tools

– Allow Images

http://marinerodeaguadulce.com/foro/

[John James Jacoby]

Also, when I register a new user through WordPress as per normal, that user is still not assigned a role in bbPress. Not when they login, not when they hit the forum for the first time. Not ever.

My Steps:

1. I used a Chrome browser window to register a new user through WordPress
2. Logged in via WordPress
3. Hit the forum
4. User could not post, looks like has no role
5. Logged out via WordPress
6. Used FireFox to login as admin to check new user role
7. No Role Assigned
8. Used Chrome to login through bbPress
9. Hit the forum
10. User could not post, looks like has no role
11. Used Firefox admin to edit Test user
12. Received typical error message (noted below)

Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /forums/bb-includes/functions.bb-template.php on line 2009

Basically it looks like the exact same error message as before, with the same circumstances.

---

Round two using alpha 5 trunk from the SVN went exactly the same way, only this time when I logged in via bbPress, the above Warning went away, but that user is still marked as Inactive by default when they should be a Member according to the role map.

---

When registering through bbPress, the new user still is not assigned a Role on the WordPress side either.

---

Sam, can you explain to me what was supposed to be different in alpha5? Maybe I misunderstood…

[chrishajer]

Yes

https://bbpress.org/forums/topic/get-latest-topics-performance-problem-and-solution#post-22403

https://bbpress.org/forums/topic/get-latest-topics-performance-problem-and-solution#post-22424

https://wordpress.org/support/

[Ben L.]

Untested code below:

<?php $bb_post = $posts[0]; unset($posts[0]);   $del_class = post_del_class();?>

<div id="post-<?php post_id(); ?>"<?php alt_class('post', $del_class); ?>>

<?php bb_post_template(); ?>

</div>

<h6>Responses</h6>

<ol id="thread" start="<?php echo $list_start; ?>">

<?php foreach ($posts as $bb_post) : $del_class = post_del_class(); ?>

<li id="post-<?php post_id(); ?>"<?php alt_class('post', $del_class); ?>>

<?php bb_post_template(); ?>

</li>

<?php endforeach; ?>

</ol>

[-skipper-]

Based on Scoun theme from Mike Lothar.

Plugins used:

– Akismet

– Human Test for bbPress

– bbpress SEO tools

– Allow Images

http://marinerodeaguadulce.com/foro/

[Sam Bauers]

Same implementation now in 0.9 branch, if someone could confirm 0.9 that would be great.

[Sam Bauers]

Changes are now in trunk, please test.

0.9 may be a little more hackish to implement.

[anotherdan]

Chris, My page went from loading in 2-8 seconds to 0.200 – 0.300 per request… So yes it was severe – as I said i use this function more than once in the theme…

Ahh there of course is the join filter… Thanks CK I will move this out, so I am able to update the core without a problem… I have another “extremely slow” issue, but I will get back to that later because that’s in the bb-admin part so only few people see that…

[Sam Bauers]

I’ll adjust core in trunk and 0.9 branch to implement this somehow.

[_ck_]

>> The same performance gain is achieved using the existing forum_time index.

Ah so in that case, no ALTER required and there is zero extra storage required and the plugin can be used like this:

<?php

/*

Plugin Name: Topic Time Index

*/

add_filter('get_latest_topics_join','topic_time_index',99999);

function topic_time_index($join) {return " $join USE INDEX(forum_time) ";}

?>

[_ck_]

Chris, you are missing the concept that if there are 100 people hitting the mysql server with the same or different queries and they can’t be cached, the load goes up exponentially.

Sam’s benchmark is on a high performance, dedicated mysql server.

Imagine someone with 40,000 records, non-indexed, on a shared server.

[Sam Bauers]

@chrishajer

It depends how many times that 1/10th of a second happens per second.

[Sam Bauers]

The same performance gain is achieved using the existing forum_time index.

[chrishajer]

I think it’s cool that the index and the mini-plugin can improve on bbPress, but “severe performance issues” to me is not going from 0.0920 to 0.0005 seconds. That’s from 1/10 of a second to nearly nothing. But 1/10 second was “severe performance issues”?

Or, does this query from _ck_ just show a way to measure the improvement, where in actual usage, someone with 10K topics or 42K topics would see a performance hit (delay) much different than the test query that _ck_ posted. I’m all for improving what can be improved, but there are much larger issues to worry about than something that is taking 1/10th of a second. With bandwidth and browsers being what they are, the page isn’t going to load that quickly anyway, and adding 1/10 of a second to the processing time is not going to be noticeable to me.

[_ck_]

Very nice. So it’s definitely proven to be way faster.

But another question is, how much space does a non-unique index on 42,000 rows take?

[Sam Bauers]

Here’s the result on WordPress.com’s English support forum:

41,990 total rows



Showing rows 0 - 24 (25 total, Query took 0.0024 sec)

Showing rows 0 - 24 (25 total, Query took 0.0024 sec)

Showing rows 0 - 24 (25 total, Query took 0.0024 sec)

Showing rows 0 - 24 (25 total, Query took 0.0024 sec)

Showing rows 0 - 24 (25 total, Query took 0.0024 sec)



Showing rows 0 - 24 (25 total, Query took 0.2102 sec)

Showing rows 0 - 24 (25 total, Query took 0.2062 sec)

Showing rows 0 - 24 (25 total, Query took 0.2037 sec)

Showing rows 0 - 24 (25 total, Query took 0.2031 sec)

Showing rows 0 - 24 (25 total, Query took 0.2060 sec)

[_ck_]

I bet it only doubles the performance when it can sort in memory. Once it spills into a temporary disk sort, then you start seeing a more radical increase in performance between the forced index and not.

I should also point out the mini-plugin (and index) will also help on any forum/sub-forum page in addition to the front-page. So all that extra index storage is at least multi-purpose.

One way to boost this even further would be to ORDER BY the topic_last_post_id and then use the last_post_id as a UNIQUE index (key) since no two posts can have the same post_id (and no two topics can have the same last post_id). topic_time is not unique at all so it takes a tad longer for mysql to sort/larger index.

[chrishajer]

With 615 topics, .0095 vs .0044 (~twice as fast). This is MySQL 4.0.27.