[OzzModz] Mark All Conversations [Paid] 2.0.0 Patch Level 1

Mark all conversations as read, unread, starred or unstarred.
implemented with XF's job manager so has not performance impact with large amount of conversations.

View attachment 5185

View attachment 5186

View attachment 5187

View attachment 5188

Click to expand...

Painbaker said:

B beakernz Which exactly action?
Can you send me via PM your slow query log? (enable in MySQL configuration)



UPDATE/DELETE queries can be slow on large forums with millions conversations.
Your MySQL server must be configured for faster performance by experienced system administrator. I just can advise to increase the innodb_buffer_pool_size or move database to server with higher I/O.

There is nothing we can do about this on the add-on side. The operations is already performed through the job scheduler to reduce the impact on server performance.

Click to expand...

Painbaker said:

Synthetic tests on my dev forum with 2000 conversations in total takes 5 seconds to mark all conversations as read/unread.

What matters is the size of the conversation tables and the characteristics of the server.

Click to expand...

Changelog:
- Feature: added action to leave all conversations
- Fix: hide "mark all" button if no conversations available
- Fix: reset inlinemod cookie
- Fix: PHP < 7.2 compatibility

View attachment 7727

Click to expand...

themago said:

I have 8k unread conversations that I want to mark as read, when I click "mark all conversations" it loads for a while but then just stops / timesout... No error message or change on the page it just stops loading

Click to expand...

2.0.0 Patch Level 1:
- Fix: calculate optimal batch to avoid execution timeout errors

Click to expand...