#1 WordPress forum plugin created by gVectors Team

wpForo – WordPress Forum Plugin
  • Home
  • Forum
  • Migrate to wpForo
  • Addons
  • Documentation

Forum

Home | Forum

wpDiscuz - WordPress Comment Plugin
  • Forums
  • Members
  • Recent Posts
Forums
Main Support Forums
General Discussions
Performance
 
Share:
Notifications
Clear all

Performance  

Page 1 / 4 Next
    Last Post
RSS

jost
Posts: 33
 jost
Topic starter
April 22, 2017 10:01 pm
(@jost)
Eminent Member
Joined: 4 years ago

I just gave wpForo a go with a 300K+ forum, imported from bbPress.

The import script went flawless.

Then I loaded tested the bbPress forum versus the wpForo forum.
I simulated 200 users for 1 minute.  Here are the results.

bbPress result attached

 

Screen-Shot-2017-04-22-at-5.32.17-PM.png
15 Replies
jost
Posts: 33
 jost
Topic starter
April 22, 2017 10:02 pm
(@jost)
Eminent Member
Joined: 4 years ago

Here is wpForo

Screen-Shot-2017-04-22-at-5.32.07-PM.png
Reply
jost
Posts: 33
 jost
Topic starter
April 22, 2017 10:05 pm
(@jost)
Eminent Member
Joined: 4 years ago

wpForo average response time was a little less than HALF of bbPress.

 

However, it still was nowhere close to non-wordpress based forum software so I ran a profile on a page where I was reading a topic.

wpForo executed over 360 SQL queries just for reading a topic.

Compare that to my old phpBB forum which only executes 16.

Although a nice improvement over bbPress, it just doesnt perform fast enough for our clients 🙁

I could run 30 phpBB forums on the same hardware versus wpForo.

Reply
jost
Posts: 33
 jost
Topic starter
April 22, 2017 10:07 pm
(@jost)
Eminent Member
Joined: 4 years ago

I also suspect that because wpForo does not use a unique INTEGER ID in its url's it is forced to run a SQL query against a CHAR column when searching for topics.  This is very slow when dealing with a forum that has 300K or 1 million+ posts.

I would suggest tweaking your software to add a unique postID to each URL for much faster queries.

And finally, please reduce the number of queries. Would love to use this software but I need it 10X faster than it is today.

 

Reply
jost
Posts: 33
 jost
Topic starter
April 22, 2017 10:14 pm
(@jost)
Eminent Member
Joined: 4 years ago

Checked on a query.

 

"SELECT *

FROM `wp_wpforo_topics`
WHERE `slug` ="   /etc

 

This is where you guys find the post via the slug. The query is surprisingly fast, so I stand corrected.  Doesnt seem to be a need for a unique INTEGER in the URL.

 

It seems the huge number of queries, all which are individually fast, when added together, cause a high load and a sluggish site.   > 1 second response time is too slow.

 

 

Reply
Page 1 / 4 Next
  All forum topics
  Previous Topic
Next Topic  

Forum Search

Join Us!

Download wpForo plugin
on WordPress.org

wpForo Addons

wpforo-private-messages  wpforo-advanced-attachments-128x128  wpforo-embeds-128x128 wpForo User Custom Fields addon  wpForo – Blog Cross Posting addon  wpForo Ads Manager
View all Addons »

Recent Topics

  • Subscribing through the subscription manager in some cases doesn't update the "subscribe to topics" button on forum

    By afreymuth, 10 hours ago

  • a little problem, I need help, thanks

    By adultwork, 12 hours ago

  • How to configure: When click on Topic it goes to 1st page (Topic starter)

    By nalin_duminda, 14 hours ago

  • Seeking assistance solving new users not getting a confirmation emails on WP Multisite

    By Hansie, 15 hours ago

  • White text on White background...again and again...

    By Morosirus, 20 hours ago

  • display a shortcode in the category description

    By mazohho, 21 hours ago

Topic Tags

  • new features43
  • seo39
  • translation36
  • plugin conflict35
  • forum33
  • buddypress31
  • login31
  • threaded layout30
  • registration29
  • ultimate member28
  • moderation27
  • editor25
  • avatar24
  • shortcode24
  • css23
  • tags22
  • menu21
  • migration20
  • url20
  • profile20
View all tags (1474)

Recent Posts

  • RE: Fatal error:

    @robert OK, thanks my prob...

    By Bujkilla, 5 hours ago

  • RE: Views are no longer counted

    Again , Views are counted very well, but not in real...

    By Robert, 9 hours ago

  • RE: How are "views" calculated?

    Please read this topic attentive from first post. It's ...

    By Robert, 9 hours ago

  • Subscribing through the subscription manager in some cases doesn't update the "subscribe to topics" button on forum

    Hi,I think this is just a development oversight more th...

    By afreymuth, 10 hours ago

  • a little problem, I need help, thanks

    Hello,I'm not sure if I posted where I should, but I wa...

    By adultwork, 12 hours ago

  • How to configure: When click on Topic it goes to 1st page (Topic starter)

    Currently when click on topic it goes to the last page ...

    By nalin_duminda, 14 hours ago

  • Seeking assistance solving new users not getting a confirmation emails on WP Multisite

    Problem: When a new user registers through WPForo, they...

    By Hansie, 15 hours ago

Share:
  Forum Statistics
20 Forums
7,788 Topics
39 K Posts
6 Online
14.9 K Members

Latest Post: Fatal error: Our newest member: soikeotaixiu Recent Posts Unread Posts Tags

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo | Copyright © 2016-2021 gVectors Team
Copyright Registration Service - Click here for more information or to register work
wpForo is Registered with the IP Rights Office
Copyright Registration Service

Ref: 4477265538
  • Home
  • Forum
  • Migrate to wpForo
  • Addons
  • Documentation