[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