After clicking Submit Reply, saving is very slow

[sofos]

Hi guys, for a few days now, after writing a post and clicking 'Submit Reply' it takes 10 to thirty seconds to save the post.

This does not happen on the post editing function and happens even without advertising and with all plugins disabled.

Do you have any advice for me?

Edited November 15, 2023 by sofos

[teraßyte]

Does the topic you're replying to have a lot of followers? Or does it happen also for topics with few or zero followers?

[sofos]

hi @teraßyte it also happens for topics with zero followers but it seems that the delay is greater in discussions with many participants (those who follow the discussions are few, three or four for each discussion).

I can do some tests if you think it helps.

[teraßyte]

I think that notifications might be delaying the submission process. What Email method are you using to send out notifications? PHP mail, SMTP, Sendgrid?

[sofos]

I did some tests, the delay seems independent of the number of posts and followers

@teraßyte I am using a SMTP by ovh.net

[teraßyte]

Instead of the number of followers, it might just be the SMTP server being slow in its starting reply. Switch temporarily to PHP mail and try again to post something. Does the delay disappear?

Edited November 15, 2023 by teraßyte

[Marc]

1 hour ago, sofos said:

I did some tests, the delay seems independent of the number of posts and followers

@teraßyte I am using a SMTP by ovh.net

If there are a lower number of followers then it would attempt to send them immediately. So if the SMTP is slow, then indeed it would be what is causing the delay there

[loccom]

We use sendgrid and it's great. Much more reliable than phpmail or smtp. most notificatons arrive using sendgrid.

[sofos]

@teraßyte @Marc Stridgen

switching to PHP mail doesn't seem to have any effect

[Jim M]

7 minutes ago, sofos said:

@teraßyte @Marc Stridgen

switching to PHP mail doesn't seem to have any effect

If PHP mail runs on the same SMTP server, you would indeed have the same issue. That would be a question for your hosting provider.

[sofos]

@Jim M

switching to sendgrid doesn't seem to have any effect

Reoccurring system log entry (169 times)

OutOfRangeException: (0) #0 /var/www/vhosts/ myforum.com/httpdocs/system/Theme/Theme.php(401): IPS\Patterns\_ActiveRecord::load() #1 /var/www/vhosts/ myforum.com/httpdocs/system/Dispatcher/Standard.php(54): IPS\_Theme::i() #2 /var/www/vhosts/ myforum.com/httpdocs/system/Dispatcher/Front.php(760): IPS\Dispatcher\_Standard::baseCss() #3 /var/www/vhosts/ myforum.com/httpdocs/system/Dispatcher/Front.php(76): IPS\Dispatcher\_Front::baseCss() #4 /var/www/vhosts/ myforum.com/httpdocs/system/Dispatcher/Dispatcher.php(110): IPS\Dispatcher\_Front->init() #5 /var/www/vhosts/ myforum.com/httpdocs/index.php(13): IPS\_Dispatcher::i() #6 {main}

[Jim M]

16 minutes ago, sofos said:

@Jim M

switching to sendgrid doesn't seem to have any effect

Reoccurring system log entry (169 times)

OutOfRangeException: (0) #0 /var/www/vhosts/ myforum.com/httpdocs/system/Theme/Theme.php(401): IPS\Patterns\_ActiveRecord::load() #1 /var/www/vhosts/ myforum.com/httpdocs/system/Dispatcher/Standard.php(54): IPS\_Theme::i() #2 /var/www/vhosts/ myforum.com/httpdocs/system/Dispatcher/Front.php(760): IPS\Dispatcher\_Standard::baseCss() #3 /var/www/vhosts/ myforum.com/httpdocs/system/Dispatcher/Front.php(76): IPS\Dispatcher\_Front::baseCss() #4 /var/www/vhosts/ myforum.com/httpdocs/system/Dispatcher/Dispatcher.php(110): IPS\Dispatcher\_Front->init() #5 /var/www/vhosts/ myforum.com/httpdocs/index.php(13): IPS\_Dispatcher::i() #6 {main}

You may wish to investigate what is happening with your community. Attempting to sign in from the ACP, I keep getting redirected around. If you have any custom redirects on the server imposing HTTP to HTTPS or otherwise. I would remove those.

[sofos]

No results so far. 😔

I've noticed that sometimes posts are duplicated, does this tell you anything?

[Marc]

Usually that there are issues with the site saving data at times. 

[sofos]

hi @Marc Stridgen, issue on server side? Do you have anything you recommend checking out?

[Marc]

Usually, performance issues with your mysql instance and/or mailing. 

[sofos]

@Marc Stridgen there are two queries thrown continuously:

Quote

/*forum::forum::IPS\Content\Search\Mysql\_Index::index:306*/ INSERT INTO `core_search_index`

Quote

/*forum::forum::IPS\Session\Store\_Database::updateSession:381*/ INSERT INTO `core_sessions` ( `id`, `member_name`, `seo_name`, `member_id`, `ip_address`, `browser`, `running_time`, `login_type`, `member_group`, `current_appcomponent`, `current_module`, `current_controller`, `current_id`, `uagent_key`, `uagent_version`, `uagent_type`, `search_thread_id`, `search_thread_time`, `data`, `location_url`, `location_lang`, `location_data`, `location_permissions`, `theme_id`, `in_editor` ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ON DUPLICATE KEY UPDATE `id`=VALUES(`id`), `member_name`=VALUES(`member_name`), `seo_name`=VALUES(`seo_name`), `member_id`=VALUES(`member_id`), `ip_address`=VALUES(`ip_address`), `browser`=VALUES(`browser`), `running_time`=VALUES(`running_time`), `login_type`=VALUES(`login_type`), `member_group`=VALUES(`member_group`), `current_appcomponent`=VALUES(`current_appcomponent`), `current_module`=VALUES(`current_module`), `current_controller`=VALUES(`current_controller`), `current_id`=VALUES(`current_id`), `uagent_key`=VALUES(`uagent_key`), `uagent_version`=VALUES(`uagent_version`), `uagent_type`=VALUES(`uagent_type`), `search_thread_id`=VALUES(`search_thread_id`), `search_thread_time`=VALUES(`search_thread_time`), `data`=VALUES(`data`), `location_url`=VALUES(`location_url`), `location_lang`=VALUES(`location_lang`), `location_data`=VALUES(`location_data`), `location_permissions`=VALUES(`location_permissions`), `theme_id`=VALUES(`theme_id`), `in_editor`=VALUES(`in_editor`)

 

[Marc]

These are things you would need to take up with your host. These really are simple queries that should be running efficiently

[sofos]

SOLVED! 

Data Storage Method

FROM MySQL Database

TO File System

[Marc]

Glad to hear thats now resolved for you