[PHPBB3-11403] Multiinsert for notifications should use batches

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Blocker
Resolution: Fixed
Affects Version/s: 3.1.0-dev
Fix Version/s: 3.1.0-a1
Component/s: Database Abstraction Layer (DBAL), Notification System
Labels:
None

GitHub Pull Request URL:
https://github.com/phpbb/phpbb3/pull/1306

Description

Currently my DB goes away when notifications for unread posts are added for 20k Users. The problem is they are all added in one query, using sql_multi_insert().
EXreaction said, the function itself could also split the sets up into batches. (Would avoid duplicated code everywhere)

Attachments

Activity

People

Assignee:: Andreas Fischer

Reporter:: Joas Schilling [X] (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 06/Mar/13 6:45 AM

Updated:: 22/Jan/17 4:01 PM

Resolved:: 29/Mar/13 3:56 PM