[$75] Slowness in Posting discussions

[sdgun]

Steps
Log into forums as any user
Click New Discussion
Select a category and add some text
Click Post Discussion

The Post Discussion button is getting enabled but the post is not being added for a few seconds, if user clicks the Post Discussion again it shows an error message

Screencast 2020-11-25.zip

[jmgasper]

Contest https://www.topcoder.com/challenges/30154455 has been created for this ticket.

This is an automated message for ghostar via Topcoder X

[jmgasper]

Contest https://www.topcoder.com/challenges/30154455 has been updated - it has been assigned to obog.

This is an automated message for ghostar via Topcoder X

[jmgasper]

@atelomycterus - Any thoughts on what we might be able to do to speed this up?

[atelomycterus]

@jmgasper In sdgun's video the Advanced editor is used. I've also noticed it works slowly.

Whatever editor we use vanilla does :

• save a draft every minute in a background (autosave feature); save/remove a draft for preview only

if User presses Save,

• remove a draft
• validate a post. The Discussion model fires several events (BeforeSaveDiscussion and so on). Some plugins can also perform different actions with DB, which can also affect performance. For example, check for flood control, check if User is spamming and so on
• save a post
• update User Discussion Count (User table)
• update calculated columns in Category table. For example, new post is added => LastDiscussionID, LastUserID and others will be updated in Category table.
• update cache (Category, Discussion)
• update the attachment status of attachemnts in a discussion
• generate activity records for notifications
• render a page. The Discussion Controller fires events (BeforeRendering and so on). Some plugins can also perform different actions with method's hooks, which can also affect performance.

If Users are not satisfied with the performance, we can measure methods, all plugin's hooks, etc.

P.S. In the video, Spam control error

You can configure it in Moderation. I'll check how it can be configured with config.php.

UPDATED: I added the params in config.php. PR- #242

[jmgasper]

@sdgun - Can you retest with the latest updates please?