We're updating the issue view to help you get more done.Learn more

Reduce transaction size when updating tagging counts

Right now, when we write taggings_count updates from redis to mysql, we do so in batches and create a sql transaction for each batch. In order to make the database happier, we'd like to reduce the size of the batches down from 1000 to 100, and make that configurable so that it's easier to change in the future.

Testing: tagging counts should still update, and nothing should be visibly different.

Status

Assignee

elzj78 (Elz)

Reporter

elzj78 (Elz)

Roadmap

Tags

Priority

Medium

Affects versions

0.9.219

Fix versions

Components

BackEnd

Difficulty

Medium

Milestone

Internal 0.9